How to find 3rd highest salary of an employee from the employee table

1.	How to find 3rd highest salary of an employee from the employee table in SQL?
Answer» SELECT salary FROM employee E1 WHERE 3-1 = (SELECT COUNT(DISTINCT salary) FROM employee e2 WHERE e2.salary > e1.salary) Our updated SQL interview questions queries for FRESHERS are the best online resource to help you prepare for the upcoming interviews.

How to find 3rd highest salary of an employee from the employee table in SQL?

Answer»

SELECT salary FROM employee E1 WHERE 3-1 = (SELECT COUNT(DISTINCT salary) FROM employee e2 WHERE e2.salary > e1.salary)

Our updated SQL interview questions queries for FRESHERS are the best online resource to help you prepare for the upcoming interviews.