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