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 vote257 views2 answers
Wordpress change url in database
SQL
0 vote202 views1 answer
Postgresql update to unique
SQL
0 vote192 views2 answers
Database owner can't create new tables postgres
SQL
0 vote244 views1 answer
Mysql config address
SQL
0 vote213 views2 answers
Dumping sql table
SQL
1 vote197 views1 answer
Postgres first_value in gropby
SQL
0 vote189 views1 answer
Postgresql create user roles
SQL
0 vote239 views1 answer
Mysql bind-address default value
SQL
1 vote205 views1 answer
Psql view enum values
SQL
2 votes147 views1 answer
Foreign key example in dbms
SQL