/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 vote163 views1 answer
Select new table sql
SQL
0 vote146 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote141 views1 answer
Psql initialization
SQL
0 vote142 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote144 views1 answer
Mysql multiple primary keys
SQL
0 vote161 views1 answer
Full outer join in mariadb mysql
SQL
0 vote161 views2 answers
Mysql insert into multiple tables
SQL
0 vote145 views1 answer
Copying query result to excel
SQL
1 vote158 views3 answers
Rows, INSERT INTO
SQL
2 votes154 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL