Question 3: MySQL ---------- Nth Highest Salary, salary

Question 3: MySQL ---------- Nth Highest Salary, salary

Write a SQL query to get the nth highest salary fromEmployeeTable.

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

For example, given the above Employee table, the nth highest salary where n = 2 is200. If there is no nth highest salary, then the query shocould returnNull.

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 Employee order by Salary desc limit m, 1); END