sqlserverå页
第ä¸ç§å页æ¹æ³
éç¨å°çåæ°:
pageSize æ¯é¡µæ¾ç¤ºå¤å°æ¡æ°æ®
pageNumber é¡µæ° ä»å®¢æ·ç«¯ä¼ æ¥
totalRecouds 表ä¸çæ»è®°å½æ° select count (*) from 表å
totalPages æ»é¡µæ°
totalPages=totalRecouds%pageSize==0?totalRecouds/pageSize:totalRecouds/pageSize+1
pages 计ç®åpages æ¡æ°æ®
pages= pageSize*(pageNumber-1)
SQLè¯å¥:
select top pageSize * from 表å where id not in (select top pages id from 表å order by id) order by id
第äºç§å页æ¹æ³
pageSize æ¯é¡µæ¾ç¤ºå¤å°æ¡æ°æ®
pageNumber é¡µæ° ä»å®¢æ·ç«¯ä¼ æ¥
pages=pageSize*(pageNumber-1)+1
select top pageSize * from 表å where id>=(select max(id) from (select top pages id from 表å order by id asc ) t )
mysqlå页
éç¨å°çåæ°:
pageSize æ¯é¡µæ¾ç¤ºå¤å°æ¡æ°æ®
pageNumber é¡µæ° ä»å®¢æ·ç«¯ä¼ æ¥
totalRecouds 表ä¸çæ»è®°å½æ° select count (*) from 表å
totalPages æ»é¡µæ°
totalPages=totalRecouds%pageSize==0?totalRecouds/pageSize:totalRecouds/pageSize+1
pages èµ·å§ä½ç½®
pages= pageSize*(pageNumber-1)
SQLè¯å¥:
select * from 表å limit pages, pageSize;
mysql å页ä¾èµäºå
³é®å limit å®é两个åæ°:èµ·å§ä½ç½®åpageSize
èµ·å§ä½ç½®=页大å°*(页æ°-1)
èµ·å§ä½ç½®=pageSize*(pageNumber -1)
oracleå页
pageSize æ¯é¡µæ¾ç¤ºå¤å°æ¡æ°æ®
pageNumber é¡µæ° ä»å®¢æ·ç«¯ä¼ æ¥
totalRecouds 表ä¸çæ»è®°å½æ° select count (*) from 表å
totalPages æ»é¡µæ°
totalPages=totalRecouds%pageSize==0?totalRecouds/pageSize:totalRecouds/pageSize+1
startPage èµ·å§ä½ç½®
startPage= pageSize*(pageNumber-1)+1
endPage=startPage+pageSize
SQLè¯å¥
select a.* from
(
select rownum num ,t.* from 表å t where æå=æå¼ order by id asc
)a
where a.num>=startPage and a.num<endPage
db2å页
int startPage=1 //èµ·å§é¡µ
int endPage; //ç»æ¢é¡µ
int pageSize=5; //页大å°
int pageNumber=1 //请æ±é¡µ
startPage=(pageNumber-1)*pageSize+1
endPage=(startPage+pageSize);
SQLè¯å¥
select * from (select å段1,å段2,å段3,å段4,å段5,rownumber() over(order by æåºå段 asc ) as rowid from 表å )as a where a.rowid >= startPage AND a.rowid <endPage
accesså页
pageSize æ¯é¡µæ¾ç¤ºå¤å°æ¡æ°æ®
pageNumber é¡µæ° ä»å®¢æ·ç«¯ä¼ æ¥
pages=pageSize*(pageNumber-1)+1
SQLè¯å¥
select top pageSize * from 表å where id>=(select max(id) from (select top pages id from 表å order by id asc ) t )
温馨提示:答案为网友推荐,仅供参考