1Here is the solution for nth highest
2salary from employees table
3
4SELECT FIRST_NAME , SALARY FROM
5(SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER
6(ORDER BY SALARY DESC) AS SALARY_RANK
7FROM EMPLOYEES)
8WHERE SALARY_RANK = n;
1Here is the solution for 3rd highest
2salary from employees table
3
4SELECT FIRST_NAME , SALARY FROM
5(SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER
6(ORDER BY SALARY DESC) AS SALARY_RANK
7FROM EMPLOYEES)
8WHERE SALARY_RANK = 3;