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 vote224 views1 answer
Date 3 months from today sql
SQL
0 vote193 views3 answers
Postgresql grant alter table to user
SQL
0 vote209 views1 answer
Mysqldump don't drop table
SQL
7 votes228 views6 answers
Mysql group concat
SQL
0 vote197 views1 answer
Mysql start of today
SQL
6 votes197 views1 answer
Phpmyadmin reset root password
SQL
0 vote192 views1 answer
Postgres create database if not exists
SQL
42 votes277 views6 answers
Sql query duplicate rows
SQL
1 vote214 views1 answer
Convert epoch to date in sql server
SQL
0 vote228 views3 answers
Join
SQL