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

select field1, min(field2) as Field2 from yourTable group by 1