Re: sort data so that most frequent name appears last

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <0E8DDB66-1D4C-41A1-A6BA-AC5E3D930B4B@xxxxxxxxxxxxx>,
DRMK@xxxxxxxxxxxxxxxxxxxxxxxxx says...

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

Example:

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