1.sqlserver
select top pageSize * from tablename
2.mysql
select * from tablename
limit pages, pageSize;
pages :页码
pagesize:页行数
3.oracle
select * from (
select rownum rum from tablename where 1=1
) where rum>=min and rum< max
4.db2
int startPage=1 //起始页
int endPage; //终止页
int pageSize=5; //页大小
i
nt pageNumber=1 //请求页
startPage=(pageNumber-
1)*pageSize+1
endPage=(startPage+pageSize);
select * from (select 字段
1,字段2,字段3,字段4,字段5,rownumber() over(order by 排序字段 asc ) as rowid from tablename )as a where a.rowid >= startPage AND a.rowid <endPage