3rd Highest Salary In Sql Code Example

Example 1: 3rd highest salary in sql

Here is the solution for 3rd highest salary from employees table   SELECT FIRST_NAME , SALARY FROM  (SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS SALARY_RANK FROM EMPLOYEES) WHERE SALARY_RANK = 3;

Example 2: nth highest salary

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

Example 3: nth highest salary in sql

Here is the solution for nth highest salary from employees table   SELECT FIRST_NAME , SALARY FROM  (SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS SALARY_RANK FROM EMPLOYEES) WHERE SALARY_RANK = n;

Example 4: n highest salary in sql

SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP N salary FROM #Employee ORDER BY salary DESC ) AS temp ORDER BY salary

Example 5: second highest salary in sql

SELECT MAX(SALARY) 'SECOND_MAX' FROM EMPLOYEES WHERE SALARY <> (SELECT MAX(SALARY) FROM EMPLOYEES);   OR  Here is the solution for nth highest salary from employees table   SELECT FIRST_NAME , SALARY FROM  (SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS SALARY_RANK FROM EMPLOYEES) WHERE SALARY_RANK = n;

Example 6: third highest salary in sql

SELECT * FROM Employee WHERE sal =           (             SELECT MIN(sal) FROM Employee              WHERE  sal IN (                                  SELECT DISTINCT TOP N                                      sal FROM Employee                                           ORDER BY sal DESC                              )         )