Post #2448

📊𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 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!