Queries and Solutions › Category: MySQL › How to find third highest salary in mysql?
0 Vote Up Vote Down
bestonetechnologies Staff asked 8 years ago

How to find third highest salary in mysql?

Question Tags:
0 Answers
0 Vote Up Vote Down
bestonetechnologies Staff answered 8 years ago

SELECT DISTINCT salary FROM EMP ORDER BY salary DESC LIMIT 2 , 1
OR
select max(salary) from emp where salary < (select max(salary) from emp where salary < (select max(salary) from emp))

Your Answer

0 + 0 =