oracle、mysql、sqlserver、POSTGRESQL分页方式

页码：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 ;