/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 vote160 views1 answer
Mysql beautifier terminla
SQL
7 votes157 views3 answers
Sql fill table with info from anothe rtable
SQL
1 vote142 views1 answer
How refresh navicat tables to see new tables
SQL
20 votes169 views4 answers
Reset auto increment in MySQL
SQL
9 votes182 views3 answers
Sequence postgresql
SQL
0 vote161 views1 answer
Turnicate in mysql
SQL
1 vote161 views1 answer
Display total number of tables in mysql
SQL
0 vote160 views1 answer
Open postgresql.conf in centos
SQL
0 vote150 views1 answer
How to output a different column name in mysql
SQL
0 vote276 views1 answer
How to use select union and loop
SQL