//db2数据库分页查询 row_number() 作为人为的添加一列作为给每一条数据进行编号 over()中是实现排序的字段和方式,R代表row_number()列的别名 ,HISTORY 代表表IPS_T_PRO_CAT_AUT_HISTORY的别名
SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY CREATE_TIME DESC ) AS R,HISTORY.* FROM IPS_T_PRO_CAT_AUT_HISTORY HISTORY WHERE HISTORY.AUTHORIZE_ORG_ID='8aa880e24f24da5e014f25bfc4c00021')
WHERE R BETWEEN 1 AND 30;
//如果是Oracle数据库分页查询 ROWNUM 作为人为的添加一列作为给每一条数据进行编号
SELECT A.* FROM (SELECT ST.*,ROWNUM R FROM STUDENT AS ST) A WHERE R BETWEEN 3 AND 5;
//mysql执行简单的分页 关键字limit
SELECT * FROM STUDENT LIMIT 1,10;