191问答库 > String sql="select *from(select rownum as r,t.*from(select TBL_Message.*from TBL_Message order by

String sql="select from(select rownum as r,t.from(select TBL_Message.*from TBL_Message order by

2025-04-25 01:25:36

推荐回答（1个）

回答1：

select *from(select rownum as r,t.* from(select TBL_Message.*from TBL_Message order by postTime desc)t where rownum<= pageSize*page) where r>pageSize*(page-1);
select * from (select 行号 as r,t.* from (根据postTime 倒排序的所有信息)t where rownum <=页的大小*第几页) where r> (页的大小* (第几页-1));
这是一个分页的sql
其中rownum是行号, pagesize是传入的每页的大小就是每页多少行 page 是传入的第几页也就是你想显示第几页.