177. 第N高的薪水

MySQL实现

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

文章永久链接：https://tech.souyunku.com/43332