DBMSMediumSQL
Write a Query to Find Second Highest Salary
đ Problem
Given an Employees table with a Salary column, write a SQL query to find the second highest salary.
đ§ Approach
One clean way: find the maximum salary that is strictly less than the overall maximum salary. A subquery gets the overall max, and the outer query finds the max among everything below that.