Code Snippet posted by:
Sourabh07 | Posted on: 10/23/2012 | Category:
SQL Server Codes | Views: 361 | Status:
[Member] |
Points: 40
|
Alert Moderator
In the followin query:
'N' represents
Nth Highest Salary eg: 1st Highest Salary, 2nd Highest Salary etc.
Query:
Select top(1) *
From Table_Name
Where Pk_ID_Column in
(
Select top(N) Pk_ID_Column
From Table_Name
Order by salary_column desc
)
Order by salary_column
Sourabh07