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 vote292 views1 answer
Spark sql convert string to date
SQL
1 vote300 views3 answers
Postgresql get difference between two dates
SQL
15 votes500 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote305 views1 answer
Mysql grant all on all databases
SQL
0 vote288 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote262 views1 answer
Sql string length postgresql
SQL
12 votes282 views2 answers
Update column data type postgres
SQL
1 vote284 views1 answer
Generate random data postgresql
SQL
0 vote257 views1 answer
Sql change default collation to utf8
SQL
0 vote329 views1 answer
Compress sql file database ubuntu
SQL