Thanks, that outputs, but it embarrasses me to say that I forgot to mention another column in the mix, Column D has ungroupable variances. It can't be grouped.

The code you wrote is good, if there were no variances in column D, but there is also:

select colA,colB,colC,colD,max(ColF)

from mytable

group by colA,colB,colC,colD

yields this:

Col A--------Col B--------Col C--------Col D--------Col F

Same1------Same1------Same1-------random--------10

Same1------Same1------Same1-------someth--------12

Same2------Same2------Same2-------anythin--------32

Same2------Same2------Same2-------morelse--------42

This is what is desired:

Same1------Same1------Same1-------someth--------12

Same2------Same2------Same2-------morelse--------42

Obviously I don't want to group by colD:

select colA,colB,colC,ColD,max(ColF)

from mytable

group by colA,colB,colC

Yet when I do that I get: "Column 'ColD' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."