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 vote145 views2 answers
Android sqlite query join
SQL
0 vote171 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote172 views1 answer
Const pool = mysql.createpool()
SQL
0 vote199 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
11 votes168 views1 answer
Ddl materialized view
SQL
0 vote168 views1 answer
How to add boolean column in postgresql
SQL
0 vote164 views1 answer
Sql case sttement with set
SQL
3 votes188 views1 answer
What is having
SQL
7 votes183 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote205 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL