>Hi could someone clarify for me if its possible to control the Group By clause of a select statement (ordering doesn't seem to alter the results.
>
>If my select produced:
>
>Field1 Field2
> 1 a
> 1 b
> 2 b
> 2 a
>
>After a group by on Field1 how can I get the result to be:
>
>Field1 Field2
> 1 a
> 2 a
>
>Thanks in anticipation.
Caroline,
What logic outputs like that ? Is that sort on first col then on 2nd ? If so 'simple' group by needs 2 SQL :
select * from mySource order by 1, 2 desc into cursor crsTemp nofilter
select * from crsTemp group by 1
Cetin