176-Second Highest Salary.sql

-- 175 - Combine two tables - LeetCode
--
-- SQL Schema
Create table If Not Exists Employee (id int, salary int)
Truncate table Employee
insert into Employee (id, salary) values ('1', '100')
insert into Employee (id, salary) values ('2', '200')
insert into Employee (id, salary) values ('3', '300')
--
--
-- SQL Query
select max(salary) as SecondHighestSalary
from Employee
where salary < (select max(salary) as salary from Employee);