SQL query to find the third highest salary in the company
2022-09-10T15:43:19 - Vicky Chhetri
Read Time:13 Second
The question is a bit confusing for the developer, Interviewer Always asks this question in SQL.
The most straightforward way that should work in any database is to do the following:
SELECT * FROM `employee` ORDER BY `salary` DESC LIMIT 1 OFFSET 2;