177. 第N高的薪水

时间：2021-08-11 15:31:04 收藏：0 阅读：12

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  SET N = N - 1;
  RETURN (
      # Write your MySQL query statement below.
      SELECT DISTINCT Salary
      FROM Employee
      ORDER BY Salary DESC
      LIMIT N, 1
  );
END

原文：https://www.cnblogs.com/fxh0707/p/15127502.html