Mysql 中limite函数中,无法做公式运算
详见leecode第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 1 offset m), null)
);
END