每日sql练习-第二高薪水和第n高薪水

1.1求第二高的薪水

1.使用order by xx desc +limit 1,1分页查询
select salary from employee order by salary desc limit 1,1;

2.使用max函数
select max(salary) from employee where salary < (select max(salary) from employee);

1.2 求第n高的薪水

1.使用order by xx desc +limit n-1,1分页查询

2.使用min（） from(select from xx order by desc limit n)
select min(a.salary) from (select * from employee order by salary desc limit 2)a;