Query for top ten

[dcorrea]

I have a list of hospitals with totals for each hospital in one table. I need to know how to setup a query to retrieve the top 10 totals for each hospital on this one query.

Thanks,

 

[amorous]

SELECT TOP 10 FROM tablename

-VJ

 

[amorous]

to be more specific if the name is Hospitaltotal then

try something like this

SELECT TOP 10 Hospitaltotal FROM tablename

-VJ

 

[dcorrea]

Thanks for the quick reply VJ. How would I do it if I wanted the top 10 results for more than one hospital in this query?

Example:
Hospitals - A, B, C... have 20 different numerical entries each, recorded in this one table (tblHospitalTotals).

I am needing to retrieve the top 10 entries (greatest numerical entries) for each hospital.

Thanks again,

Danny

 

[amorous]

Ok then try this:

SELECT TOP 10 FROM Tablename Group By HospitalName

Hope this helps

VJ

 

[amorous]

Danny,

Sorry, my mistake. The previous wont work.

-VJ