第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
==