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

2 votes167 views2 answers
Postgresql get table names
SQL
0 vote149 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote151 views3 answers
Union SQL
SQL
0 vote143 views1 answer
Postgres create database if not exists
SQL
8 votes180 views1 answer
Oracle add datafile to tablespace
SQL
12 votes157 views2 answers
Select into insert sql server
SQL
0 vote164 views1 answer
Mysql get first 2 characters of string
SQL
0 vote172 views3 answers
Run sql command line
SQL
-1 vote149 views1 answer
How to switch user in mysql
SQL
2 votes163 views1 answer
Oracle list grants on procedure
SQL