|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 20th, 2004, 01:24 PM
|
|||
|
|||
TOP 10 Incidents HELP
HI all ..
I am trying to create a query that retrived the top ten incidents in specific terms. The problem is that i can't get the top 10s. [ The most 10 common incidents ] i know that i have to use max but i don't know how to get the only 10 results of that query.  Select column_1, max(column_2) from table1 group by column_1 Please help with this.. 
|
|
#2
March 20th, 2004, 04:57 PM
|
|||
|
|||
|
If you are using sql server you can SELECT TOP 10 * FROM table
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > TOP 10 Incidents HELP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
