177. Nth Highest Salary

it 취업을위한알고리즘문제풀이

문제

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

코드

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

문제해결방법