My SQL | Simple solution
Please upvote if you got any perspective from the solution. Thanks in advance. Happy Leetcoding!\n\n\nCREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBE
Please upvote if you got any perspective from the solution. Thanks in advance. Happy Leetcoding!\n\n```\nCREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT\nBEGIN\n  RETURN (\n      # Write your MySQL query statement below.\n      select distinct salary from Employee e where N - 1 = (\n        select count(distinct salary) from Employee e1 where e1.salary > e.salary\n      )\n  );\nEND\n```
['MySQL']