Mysql get nth highest

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  SET N = N-1;
  
  RETURN (
      # Where Salary is your column name and Employee your table
      SELECT DISTINCT(Salary) FROM Employee ORDER BY Salary DESC LIMIT N, 1
  );
END

Similar codes

1 vote225 views1 answer
Mysql search like order by best match
SQL
0 vote233 views1 answer
Stored procedures example
SQL
0 vote215 views1 answer
H2 auto increment and unique
SQL
1 vote226 views1 answer
Sql how to duplicate a table
SQL
0 vote209 views1 answer
SQL get max per id
SQL
2 votes232 views1 answer
Sql OR
SQL
3 votes211 views1 answer
Oracle revoke
SQL
6 votes229 views2 answers
What is non relational database
SQL
0 vote214 views1 answer
Storing RGBA in mysql db
SQL
0 vote248 views1 answer
Dynamic where clause in sql server stored procedure
SQL