/ DATA / 分页 mysql select * from articles limit (pageNo-1)*pageSize,pageSize orcle select * from (select rownum r,* from (select * from articles order by posttime desc) where rownum <= pageNo*pageSize) tmp where r>(pageNo-1) *pageSize;
评论区