Question

写一条sql 查找 工资第二高的人

Answer 1

这句就可以了select top 1 id from email where id<>(select top 1 id from email order by id desc) order by id desc

Answer 2

select * from 表名 order by 工资 desc limit 1,1

Answer 3

select ename
from (select ename from emp where sal < (select max(sal) from emp))
where sal >= all
(select sal from emp where sal < (select max(sal) from emp));