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 |
|
coconut
Starting Member
2 Posts |
 Posted - 2004-01-31 : 10:01:01
|
| How do i select first name of the lets say 6th highest salary of an employee?is it use Select TOP statement?Please advise. thank you |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-01-31 : 12:09:23
|
| Have a look at the following link.http://www.sqlteam.com/item.asp?ItemID=233 |
 |
|
|
coconut
Starting Member
2 Posts |
Posted - 2004-02-03 : 10:27:09
|
| thanx ehorn for the link.However, maybe I did not clarify clearly.I wanted to select the 6th highest salary earner and not the top six.So the expected result should only be 1 value of a person.is there any idea. thank you in advance for your reply. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-02-03 : 11:27:10
|
| http://www.sqlteam.com/item.asp?ItemID=566Jay White{0} |
|
|
|
|
|
|
Select Nth largest record -How to?