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 vote364 views1 answer
Write a query to peint the pattern P(20)
SQL
3 votes360 views3 answers
Order by postgres
SQL
0 vote361 views2 answers
Oracle select
SQL
0 vote338 views1 answer
Implizite joins sql
SQL
1 vote309 views1 answer
Alter user mysql native password
SQL
0 vote369 views1 answer
Postgres can integer fields be negative
SQL
0 vote339 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote361 views1 answer
If column value is null then in mysql
SQL
2 votes295 views1 answer
Sql group by different columns
SQL
1 vote363 views1 answer
Mysql show database size in mb
SQL