SQL query to find third highest salary in company

0 votes

I need to create a query that returns the company's third highest-paid employee.

I attempted to achieve this using subqueries but was unable. Here are some of my attempts:

select Max(sal)
from employee_table
where sal not in

 (select Max(sal)
from employee_table
where sal not in 

(select Max(sal)
from employee_table));
Feb 21, 2022 in Database by Vaani
• 7,060 points