177-nth-highest-salary

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

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