/SQL/Find nth highest salary of an employee

Find nth highest salary of an employee

#Method 1
SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

#Method 2
SELECT salary FROM Employee AS e1 
WHERE n-1=(SELECT COUNT(DISTINCT,salary) FROM Employee AS e2 
           WHERE e2.salary>e1.salary)

Nth highest salary

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

Source: javarevisited.blogspot.com

Similar codes

0 vote125 views2 answers
Android sqlite query join
SQL
6 votes193 views3 answers
Rename column ORACLE
SQL
1 vote151 views1 answer
How to check the mysql version mac
SQL
0 vote153 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote148 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote157 views1 answer
Add SuperUser MySQL
SQL
10 votes172 views4 answers
Inner join in update query mysql
SQL
34 votes141 views6 answers
Sql change data type
SQL
0 vote171 views1 answer
In query in sql
SQL
5 votes167 views2 answers
Mysql create database charset utf8mb4
SQL