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 vote154 views1 answer
Change filed order in mysql
SQL
0 vote151 views1 answer
Désinstaller postgresql linux
SQL
0 vote140 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote147 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote151 views1 answer
Components/Fields of Internal Table
SQL
0 vote155 views1 answer
What is SQL data store?
SQL
-1 vote149 views1 answer
Condition in orderby mysql
SQL
0 vote669 views1 answer
Sql show table name in result
SQL
0 vote152 views1 answer
Login failed for login due to trigger execution
SQL
3 votes155 views2 answers
Sql get month name
SQL