|
1
intermediate
0
beginner
0
advanced
Write the Query assuming an Employee table with Salary column.
|
|||
|
||||
20
2 Answers
|
Query to find 5th Highest salary without using SubQuery / Top. (Change 5 to any N value to get Nth highest Salary)
WITH Salaries AS
(
SELECT
Salary, ROW_NUMBER() OVER(ORDER BY Salary DESC) AS 'RowNum'
FROM
Employee
)
SELECT
Salary
FROM
Salaries
WHERE
RowNum = 5 |
|||
|
||||
|
Using Correlated SubQuery, N = 10: SELECT
Salary
FROM
Employee Emp1
WHERE 9 = /* 10th Highest Salary, N - 1 */
(
SELECT
COUNT(DISTINCT(Emp2.Salary))
FROM
Employee Emp2
WHERE
Emp2.Salary > Emp1.Salary
)
|
|||
|
||||