大数据第30天-Mysql练习题2-杨大伟

1 Create table If Not Exists Employee (Id int, Salary int);
2 
3 insert into Employee (Id, Salary) values (1, 100);
4 insert into Employee (Id, Salary) values (2, 200);
5 insert into Employee (Id, Salary) values (3, 300);

 1 方法一：
 2 select (
 3          select 
 4                DISTINCT Salary
 5          from  
 6                Employee
 7          order by
 8                Salary DESC
 9          limit 1,1
10       )  as SecondHighestSalary;
11 方法二：
12 select 
13        max(Salary) as SecondHighestSalary 
14 from 
15        Employee
16 where 
17        Salary < (select
18                        max(Salary) 
19                  from 
20                        Employee
21                 );