LeetCode: 177. Nth Highest Salary

[congr]

https://leetcode.com/problems/nth-highest-salary/

[congr]

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
SET N=N-1;
  RETURN (
      # Write your MySQL query statement below.
      SELECT DISTINCT salary from Employee
      ORDER BY salary DESC LIMIT 1 OFFSET N
  );
END