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 |
|
bennym
Starting Member
1 Post |
 Posted - 2006-02-23 : 11:39:15
|
| Hi can anyone help me maybe im just being thick but i cant for the life of me work out how to get the top ten results based on the highest number within a columnie.top2 would be name1 4name2 8name3 102name4 113i want name3 and name4 to be returnedSIMPLE well it should be aRRRRGGG HELP!!!i have tried using max but that only returns the highesthow i get the next highest etc i dont know |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-02-23 : 11:41:46
|
| select top 10 * from tableorder by secondcolumn desc |
 |
|
|
|
|
|
Top ten results