56,679
社区成员
发帖
与我相关
我的任务
分享
--假设你需要在字段ID上排序
select * from tbname order by id limit 5;
--假设是随机的前5个
select * from tbname order by rand() limit 5 ;
--假设你需要在字段ID上排序
select * from tbname order by id desc limit 5;
select * from 一张表 order by id limit 5;
select * from 一张表 order by id desc limit 5;