一、不用考虑去重
select * from gatewaycase where rpid ORDER BY rpid desc limit 1,1
select * from gatewaycase where rpid ORDER BY rpid desc limit 1 offset 1
二、考虑去重
select MAX(rpid) from gatewaycase where rpid < (select MAX(rpid) from gatewaycase)
也可以使用top命令
版权声明:本文为sinat_34241861原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。