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."