LeetCode : 177. Nth Highest Salary

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

Nth Highest Salary - LeetCode

 

CASE WHEN 

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  RETURN (
      # Write your MySQL query statement below.
      SELECT CASE WHEN COUNT(*) < N THEN NULL
                  ELSE MIN(SUB.SALARY) END
      FROM (SELECT SALARY
            FROM EMPLOYEE
            ORDER BY SALARY DESC
            LIMIT N) SUB
  );
END

 

LIMIT

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  SET N = N - 1;
  RETURN (
      SELECT DISTINCT SALARY
      FROM EMPLOYEE
      ORDER BY SALARY DESC
      LIMIT N, 1
  );
END