177. 第N高的薪水

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

题解来自
作者：zheng-cheng-xiang
链接：https://leetcode-cn.com/problems/nth-highest-salary/solution/zhu-yi-limityong-fa-by-zheng-cheng-xiang-7ncw/
来源：力扣（LeetCode）
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。

关于变量定义可参考：
https://blog.csdn.net/fanhl111/article/details/89644540