Question

mysql怎么取第二条最大记录

Answer 1

若表名是company_user，取uid最大值，可以查出uid第二条最大记录
select * from company_user where uid=(select max(uid) from company_user) limit 1,1 ;

Answer 2

select * from (select * from table where rownum <3 order by a desc) where rownum=1

Answer 3

select * from table order by 字段 desc limit 1,1;

Answer 4

可以用 select top 2 * from 表 order by 字段 desc 吧

Answer 5

select Salary from Employee group by Salary order by Salary desc limit 1,1;