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));