CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN set N := N - 1; RETURN ( # Write your MySQL query statement below. select SALARY from Employee group by SALARY order by SALARY desc limit 1 offset n ); END
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN RETURN ( # Write your MySQL query statement below. SELECT DISTINCT e.salary FROM employee e WHERE (SELECT count(DISTINCT salary) FROM employee WHERE salary>e.salary) = N-1 ); END