Thread
:
i want to get the third highest salary from a table?
View Single Post
#
2
(
permalink
)
12-13-2006, 10:52 AM
Laura G.
Posts: n/a
T-SQL
answer.
Re: i want to get the third highest salary from a table?
[sql]
SELECT top 3 * into #topthree FROM dbo.myTable
ORDER BY Emp_salary DESC
SELECT top 1 * FROM #topthree
ORDER BY Emp_salary
[/sql]
Laura G.
T-SQL