leetcode 177

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

使用子查询、distinct和limit来完成查询。