GuilinDev

Lc0177

05 August 2008

177 Nth Highest Salary

1
2
3
4
5
6
7
8
9
10
11

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  RETURN (
      # Write your MySQL query statement below.
      SELECT DISTINCT salary AS getNthHighestSalary
      FROM (
          SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS salaryRank FROM EMPLOYEE
      ) AS sub
      WHERE salaryRank=N
  );
END
This site is open source. Improve this page.