177. 第N高的薪水

2020-04-27 794 阅读1分钟

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