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

0 vote119 views2 answers
Tsql row number
SQL
31 votes131 views3 answers
Sql count
SQL
0 vote117 views1 answer
Check if table exists oracle
SQL
1 vote118 views1 answer
How to change owner in postgres
SQL
2 votes137 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote121 views1 answer
Oracle apex prevent initial load
SQL
7 votes120 views3 answers
Postgresql dump and restore db
SQL
0 vote109 views1 answer
Save single sql query result boolean spring boot
SQL
3 votes125 views1 answer
Oracle apex call duration
SQL
0 vote90 views1 answer
Sql table to store status
SQL