CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN set N=N-1; RETURN ( # Write your MySQL query statement below. select IFNULL((select distinct Salary from Employee o
题目描述sql执行顺序CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGINset N=N-1;RETURN (# Write your MySQL query statement below.select IFNULL((select distinct Salary from Employee order by Salary desc limit N,1),NULL) as getNthHighestSalary);E