法一:
select max(Salary) SecondHighestSalary
from Employee
where Salary<(select max(Salary) from Employee);
法二:
select max(Salary) SecondHighestSalary
from Employee
where Salary not in
(select max(Salary) from Employee); #注意加括号
法一:
select max(Salary) SecondHighestSalary
from Employee
where Salary<(select max(Salary) from Employee);
法二:
select max(Salary) SecondHighestSalary
from Employee
where Salary not in
(select max(Salary) from Employee); #注意加括号