LIUPENG BLOG
Liupeng
Jun 11, 2020
It takes 1 minutes to read this article.

SQL Function

##

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
      SET N := N-1;
  RETURN (
      # Write your MySQL query statement below.
      SELECT 
            salary
      FROM 
            employee
      GROUP BY 
            salary
      ORDER BY 
            salary DESC
      LIMIT N, 1
  );
END