📊 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: How do you get the 2nd highest salary in SQL?

👋 𝗠𝗲: Use ORDER BY with LIMIT or OFFSET, or a subquery.

MySQL / PostgreSQL (with LIMIT & OFFSET):

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

Using Subquery (Works on most databases):

SELECT MAX(salary)  
FROM employees  
WHERE salary < (SELECT MAX(salary) FROM employees);

🧠 Logic Breakdown:
- First method sorts and skips the top result
- Second method finds the highest salary below the max

💡 Tip: Use DENSE_RANK() if multiple employees share the same salary rank

💬 Tap ❤️ for more!