nth-highest-salary.sql

the1Riddle · web-flow · commit 1036326f84af · 2024-03-02T23:45:25.000+03:00
diff --git a/MySQL/nth-highest-salary.sql b/MySQL/nth-highest-salary.sql
@@ -3,14 +3,9 @@
 
 CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
 BEGIN
-  RETURN (
-     # Write your MySQL query statement below.
-     SELECT MAX(Salary) /*This is the outer query part */
-            FROM Employee Emp1
-            WHERE (N-1) = ( /* Subquery starts here */
-                 SELECT COUNT(DISTINCT(Emp2.Salary))
-                        FROM Employee Emp2
-                        WHERE Emp2.Salary > Emp1.Salary)
+SET N = N-1;
+  RETURN (SELECT DISTINCT(salary) FROM Employee ORDER BY salary DESC
+  LIMIT 1 Offset N   
   );
 END
 
