Nth highest salary

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

3rd height salary sql

SELECT MIN(EmpSalary) from ( 
	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
);

Similar codes

9 votes199 views4 answers
Mysql set id auto increment
SQL
5 votes204 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
10 votes147 views2 answers
Django mysql
SQL
3 votes181 views1 answer
Oracle apex message quit website
SQL
0 vote202 views1 answer
Postgresql in vs any performance
SQL
0 vote205 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote185 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote214 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote192 views1 answer
Sql select first and last record of each group
SQL
1 vote180 views1 answer
Oracle start job
SQL