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 votes215 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote227 views1 answer
Postgresql print sessions using the database
SQL
0 vote266 views1 answer
Trigger
SQL
1 vote201 views4 answers
Psql check tables command
SQL
3 votes205 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
11 votes267 views2 answers
Import mysql dump command line windows
SQL
0 vote199 views1 answer
View psql output in horizontal scrolling
SQL
10 votes229 views2 answers
Select nextval from sequence oracle
SQL
0 vote224 views1 answer
Suhaib
SQL
0 vote220 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL