/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 vote281 views1 answer
Mysql update from n to 100
SQL
0 vote306 views1 answer
Primary key multiple colums
SQL
0 vote311 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote296 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
2 votes295 views1 answer
Oracle apex list connected users
SQL
1 vote216 views1 answer
Convert money to varchar sql server
SQL
1 vote303 views1 answer
What is a Database?
SQL
1 vote269 views1 answer
Mysql show data from table
SQL
0 vote284 views4 answers
Change schema in sql server
SQL
0 vote298 views1 answer
Flexible search query delete table
SQL