Nth Highest Salary

Write a SQL query to get the nth highest salary from the Employee table.

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

for example, given the above Employee table, The n th  highest salary Where n  = 2 is 200 . If there is No n th  highest salary, then the query should Return null .

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 n,1      Select distinct salary from employee order by Sal ary DESC LIMIT M, 1  ); END

AndSecond Highest salary the same idea, but here we examine the writing of functions.

Attention:

function, you cannot define variables such as N, and then you cannot use a statement such as limit n-1,1 in a SELECT statement

Nth Highest Salary