Finding the top 10 in a Query

[chucky2000]

I need to query a table that contains a hundreds of clients. The query consists of pulling out the Top 10 or Top 30 clients as per volume. I can do this by the Count Function but this provided me with all of the clients with their volume. How would I retrieve just the Top 30 for example??
Thanks
Chucky

 

[CosmoKramer]

SELECT TOP 30 clients.........
FROM tablename
ORDER BY volume DESC;

If you don't specify the ORDER BY you will get a random set of records that meet the criteria.....