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 vote386 views3 answers
Reseed sql table primary key
SQL
0 vote344 views1 answer
Mysql add root password
SQL
0 vote352 views1 answer
Delete data from database sqlite android
SQL
-1 vote313 views1 answer
How to format tables in sqlplus
SQL
3 votes337 views1 answer
Mysql load sql from file
SQL
1 vote358 views2 answers
Insert sqlite
SQL
0 vote293 views1 answer
Check if has alpha characters sql
SQL
1 vote354 views1 answer
Mysql check string don't have number
SQL
0 vote343 views1 answer
See Foreign Key
SQL
11 votes372 views6 answers
Mysql else if
SQL