Not sorting perse, but grouping. Let's say there is only 1 field and it contains either AAA or BBB. I want to group/count only the AAA records, but not the BBB records. One resulting record for all AAA with a count, but a one-for-one match on the BBB's. I think your SQL would give me:

AAA 3
BBB 2

Where what I want is:

AAA 3
BBB 1
BBB 1

>Would this work? If not, can you explain sorting rules.

SELECT myfield, COUNT(*) ;
>  FROM mytable;
>  GROUP BY 1

>>How would I do the following?
>>
>>Raw Data:
>>

>>AAA
>>AAA
>>BBB
>>AAA
>>BBB
>>

>>Result Desired:
>>

>>AAA 3
>>BBB 1
>>BBB 1
>>