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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-19 : 07:32:32
|
| sudheer writes "My question is how do i find the top 5th highest salary in emp table.This is in sql server.it may return one or more records. so what is best apporch if we at all we have multiple solutions.thanking you in anticipation." |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-19 : 07:47:55
|
| Select top 5 empname,salary from emptable order by salary descJimUsers <> Logic |
 |
|
|
|
|
|
How to find only top 5th highest salary