HomeQuestionsWrite a sql query to find the 3rd highest salary of an employee from the employee table in SQL? Write a sql query to find the 3rd highest salary of an employee from the employee table in SQL?By Nick / February 25, 2019 Discussion Room › Category: Database&SQL › Write a sql query to find the 3rd highest salary of an employee from the employee table in SQL? 0 Vote Up Vote Down Nick asked 6 years ago SELECT salary FROM employee e1 WHERE 3-1 = (SELECT COUNT(DISTINCT salary) FROM employee e2 WHERE e2.salary > e1.salary)
Nick