mysql solution for Nth highest salary
\nCREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\n  RETURN (\n    SELECT m.salary\n    FROM\n        (\n            SELECT salary, DENSE_RANK() O
```\nCREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\n  RETURN (\n    SELECT m.salary\n    FROM\n        (\n            SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) \'rank\' \n            FROM Employee\n        ) m\n    WHERE m.rank=N limit 1\n  );\nEND\n```\n
[]