leetcode 177

发布时间 2023-04-10 17:04:41作者: Carl_ZhangJH

第N高的薪水

 

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
declare T int default 0; 
SET T = N-1;
  RETURN (
      # Write your MySQL query statement below.
      select ifnull((select distinct salary from Employee order by salary desc limit T,1), null) as getNthHighestSalary
  );
END

 

==