oracle的分页:
select uuid,shopid,name,owner,tel,compname from
(Select rownum r,uuid,shopid,name,owner,tel,compname From Tbl_shop) where r>"+startCount+" and r <="+endCount;
startCount:开始记录数
endCount:结束记录数
mysql的分页:
select * from article limit "+startCount+", "+pageSize+";
startCount:开始记录数
pageSize:每页记录数
MSSQL的分页:
select * from ( select TOP pagesize * FROM ( SELECT TOP pagesize*cureentpage * from user_table ORDER BY id ASC ) as aSysTable ORDER BY id DESC ) as bSysTable ORDER BY id ASC
pagesize: 每页显示记录数
cureentpage:当前页数
温馨提示:答案为网友推荐,仅供参考