📊 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: How do you find the Third Highest Salary in SQL?

🙋‍♂️ 𝗠𝗲: Just tweak the offset:

SELECT DISTINCT salary
FROM employees
ORDER BY salary DESC
LIMIT 1 OFFSET 2;

🧠 Logic Breakdown:
- OFFSET 2 skips the top 2 salaries
- LIMIT 1 fetches the 3rd highest
- DISTINCT ensures no duplicates interfere

✅ Use Case: Top 3 performers, tiered bonus calculations

💡 Pro Tip: For ties, use DENSE_RANK() or ROW_NUMBER() in a subquery.

💬 Tap ❤️ for more!