Interview SQL

 Find the third highest salary in the employee Table

SELECT DISTINCT amount

FROM orders

ORDER BY amount DESC

Limit 1 OFFSET 2;