Title 3:mysql----------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 .

Topic Answer:

CREATE FUNCTION getnthhighestsalary (N int) RETURNS intbegindeclare M INT; SET m=n-1;  RETURN (      # Write your MySQL query statement below.      SELECT DISTINCT Salary from the Employee ORDER by Salary DESC LIMIT M, 1  ); END

Title 3:mysql----------Nth Highest Salary