Top XX list based on how many rows contain XX

[ryan101]

I have a table with the following 3 columns:
Ticket_Number, Location, date_created

I need to return a top 3 list that contains the locations sorted by the count of each location.

For instance, say I have 10 rows total. 4 rows have "Main Office" for location, 3 have "Satellite Office", 2 have "Telecom Shop". I want to have a list that contains 3 single column rows with the names of the top 3 locations(Main Office, Satellite Office, Telecom Shop)

I can do this using multiple recordsets in VB, but I'd like to be able to do it in a single query. Any ideas?

 

[ryan101]

answer dawned on me a while after I submitted. If anyone's interested, the command I used that works is:

SELECT LOCATION, TIMES FROM(
SELECT LOCATION, COUNT(LOCATION) TIMES
FROM TABLE_NAME
GROUP BY LOCATION
ORDER BY TIMES DESC
)
WHERE ROWNUM < 6