Aspire Systems Interview Question

Write a sql query to find the top 3rd employee with highest salary

Interview Answer

Anonymous

Oct 9, 2024

SELECT id, name, salary FROM employee ORDER BY salary DESC LIMIT 1 OFFSET 2;