snippets
filter:96 snippets
sql-lc-secondhighest·sql·leetcode
SELECT MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary < (SELECT MAX(salary) FROM Employee);
sql-lc-secondhighest·sql·leetcode
SELECT MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary < (SELECT MAX(salary) FROM Employee);