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 vote146 views2 answers
Sql update from two different database
SQL
8 votes183 views6 answers
Sql insert
SQL
0 vote198 views1 answer
Python sqlalchemy connection show server
SQL
2 votes176 views1 answer
How to find constraints on a table in oracle
SQL
0 vote195 views1 answer
Add sqlcmd to path linux
SQL
5 votes197 views1 answer
Oracle list days between two dates
SQL
0 vote199 views1 answer
Mysql select all where count more than"
SQL
0 vote173 views1 answer
Get number of table colums in sql query
SQL
6 votes200 views3 answers
Date_trunc postgres
SQL
6 votes190 views2 answers
Join vs union
SQL