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

4 votes276 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote285 views1 answer
Mysql where sum > 0
SQL
1 vote256 views1 answer
Float precision in psql
SQL
0 vote241 views1 answer
Low level operator in dbms
SQL
0 vote241 views1 answer
Sql server current time without date
SQL
2 votes259 views1 answer
How to show the whole table in sql
SQL
0 vote279 views2 answers
Sql day from datetime
SQL
8 votes229 views3 answers
Duplicate entry
SQL
28 votes264 views6 answers
Mysql change user password
SQL
1 vote261 views2 answers
Changes not showing on website server odoo
SQL