Thread
:
i want to get the third highest salary from a table?
View Single Post
#
3
(
permalink
)
12-16-2006, 01:15 AM
Don D
Posts: n/a
SQL 92
answer.
Re: i want to get the third highest salary from a table?
[sql]
SELECT TOP 1 *
FROM (SELECT TOP 3 *
FROM employees
ORDER BY salary) Top3
ORDER BY salary DESC
[/sql]
Don D
SQL 92