please tell me how do i sort data in which the most frequent name appears last in the datasheet
D DRMK May 13, 2007 #1 please tell me how do i sort data in which the most frequent name appears last in the datasheet
M Michael Gramelspacher May 13, 2007 #2 please tell me how do i sort data in which the most frequent name appears last in the datasheet Click to expand... Example: SELECT last_name, COUNT(last_name) AS [last_name count] FROM Persons GROUP BY last_name ORDER BY COUNT(last_name);
please tell me how do i sort data in which the most frequent name appears last in the datasheet Click to expand... Example: SELECT last_name, COUNT(last_name) AS [last_name count] FROM Persons GROUP BY last_name ORDER BY COUNT(last_name);
