>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