getNthHighestSalary.sql

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  DECLARE _N INT;
  SET _N = N - 1;
  RETURN (
      # Write your MySQL query statement below.
      select (
        select distinct Salary from Employee order by Salary desc limit 1 offset _N
      ) as getNthSalary
  );
END