Nth Highest Salary



Write a SQL query to get the n^th highest salary from theEmployee table.

+----+--------+| Id | Salary |+----+--------+| 1  | 100    || 2  | 200    || 3  | 300    |+----+--------+

For example, given the above Employee table, the n^th highest salary wheren = 2 is 200. If there is no n^th highest salary, then the query should returnnull.

题意：找出表中工资第n高的

order by,limit 及变量的使用

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN      declare m int;      set m = n - 1;  RETURN (      # Write your MySQL query statement below.            select distinct salary from Employee order by salary desc limit m, 1  );END