Entry

How can I use "group by" and "order by" togehter?

Oct 4th, 2000 14:05
Narendra Jain, Robert M. Muench,

'order by' always comes after the 'group by' clause of the select
statement. The general format is:
select customer, count(*) as inv_cnt
from invoices
group by customer
order by inv_cnt desc;
The above query groups the invoices table by customer and arranges them
in the order of the customer with the maximum invoice.