3-line solution


  • 0
    S
      DECLARE tmp INT DEFAULT 0;
      SET TMP=N-1;
      RETURN (
          # Write your MySQL query statement below.
          SELECT distinct Salary from Employee ORDER BY Salary desc LIMIT TMP,1
      );
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.