Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Trininole
Yak Posting Veteran
83 Posts |
 Posted - 2011-04-25 : 09:55:42
|
| what is the syntax for retrieving the top 3 records and the counts of those same top 3 records?Roger DeFour |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-04-25 : 10:02:08
|
| What determines the TOP 3, the counts?JimEveryday I learn something that somebody else already knew |
 |
|
|
Trininole
Yak Posting Veteran
83 Posts |
Posted - 2011-04-25 : 10:04:31
|
| Yes the counts of services determines the top 3Roger DeFour |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-04-25 : 10:34:15
|
| select top 3 col, count(*) from tablegroup by colorder by count(*) descMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Top 3 records