nth highest salary
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\nSET N = N-1;\n  RETURN (\n      # Write your MySQL query statement below.\n    SELECT DISTINCT e.
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\nSET N = N-1;\n  RETURN (\n      # Write your MySQL query statement below.\n    SELECT DISTINCT e.salary\n      FROM Employee e\n      ORDER BY e.salary DESC\n      limit N, 1\n  );\n  \n  \n  \n  CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\nSET N = N-1;\n  RETURN (\n      # Write your MySQL query statement below.\n    SELECT DISTINCT salary\n      FROM Employee \n      ORDER BY salary DESC\n      LIMIT 1 OFFSET N\n  );\nEND\nEND
[]