常用SQL笔记MySQL
2025-04-08 23:58阅读:133评论:0
MySQL之获取上下一条记录
1
2
3
4
5
6
/*获取指定id的上一条记录，我这里是以id=5为例的*/select cid,cname from company order by cid>=5,cid desc limit 1 /*获取指定id的下一条记录，我这里是以id=5为例的*/SELECT cid,cname from company order by cid<=5,cid asc limit 1