这句就可以了select top 1 id from email where id<>(select top 1 id from email order by id desc) order by id desc
select * from 表名 order by 工资 desc limit 1,1
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));
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024