sort data so that most frequent name appears last

D

DRMK

please tell me how do i sort data in which the most frequent name appears
last in the datasheet
 
M

Michael Gramelspacher

please tell me how do i sort data in which the most frequent name appears
last in the datasheet
Example:

SELECT last_name, COUNT(last_name) AS [last_name count]
FROM Persons
GROUP BY last_name
ORDER BY COUNT(last_name);
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top