Guest_imported
New member
- Jan 1, 1970
- 0
How can i select nth maximum salary using sql server?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Query 1
- Thread starter Guest_imported
- Start date
- Status
-
1
- #2
tlbroadbent
MIS
Here is one solution in T-SQL.
SELECT Min(a.Sal) AS NthMaxSal
FROM (SELECT TOP 5 Sal From Employees Order By Sal Desc) AS a Terry
The reason why worry kills more people than work is that more people worry than work. - Robert Frost
SELECT Min(a.Sal) AS NthMaxSal
FROM (SELECT TOP 5 Sal From Employees Order By Sal Desc) AS a Terry
The reason why worry kills more people than work is that more people worry than work. - Robert Frost
Great job, Terry! A clean, elegant solution.
(Unfortunately, I am currently at work in a Sybase shop, and I was shocked to find that Sybase ASE does not support the TOP clause!) Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:
(Unfortunately, I am currently at work in a Sybase shop, and I was shocked to find that Sybase ASE does not support the TOP clause!) Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:
- Status
Similar threads
- Locked
- Question
- Locked
- Question