Top three numbers query

[generaluser]

I have a field that list ages of people. I want to run a query that gives me the top three occuring ages and how many times they occur in that field. What would be the best way to do this?
Thanks in advance for the help

 

[LittleSmudge]

This SQL code

SELECT TOP 3 MyTblX.MyNum, Count(MyTblX.MyNum) AS CountOfMyNum
FROM MyTblX
GROUP BY MyTblX.MyNum
ORDER BY MyTblX.MyNum DESC;


Selects the Top three values in the field MyNum in the table MyTblX and displays the number of occurances of each in CountOfMyNum.
( Rename as required )

QED?

G LS

 

[generaluser]

Thanks. Please check my other thread "Query based on multiple criteria". I definitely need help with that. Thanks

 

[LittleSmudge]

How about a link to it so that I can find it ?

G LS

 

[generaluser]

thread701-315064