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

1 vote166 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote102 views1 answer
Update row in sqlite python
SQL
0 vote201 views1 answer
Postgres foreign key multiple columns
SQL
0 vote192 views2 answers
Check if sql temp table exists
SQL
-2 votes254 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote143 views1 answer
Mssql current date
SQL
1 vote152 views1 answer
Convert rows to string sql server
SQL
0 vote170 views2 answers
Get item by composite primary key mysql
SQL
0 vote141 views1 answer
In mysql workbench contnent not feching
SQL
0 vote166 views1 answer
Sql query to find duplicate email address
SQL