页码:pageNo。 页数:pageSize
起始行:recordCount
ORACLE:
int rownum = pageNo * pageSize;
oracle分页也需要加WHERE
SELECT 列名 FROM (SELECT ROWNUM r,e.* FROM 表名 where XX AND ROWNUM <= rownum) WHERE r > (rownum - pageSize)
MYSQL:
SELECT * FROM tableName LIMIT recordCount ,pageSize;
SQLSERVER:
SELECT TOP pageSize * from (SELECT row_number() over(order by select 0) as a,* from tableName ) result(别名) WHERE a > ((pageNo-1)*pageSize);
POSTGRESQL:
SELECT * FROM tableName LIMIT pageSize OFFSET recordCount ;
oracle、mysql、sqlserver、POSTGRESQL分页方式
最新推荐文章于 2024-07-25 11:35:55 发布