1、Mysql数据库:Limit关键字实现分页效果
select * from tableName where 条件 limit 当前页码*页面容量-1,页面容量 两个参数:PageNo,PageSize
2、Oracle数据库: 参数:ROWNUM
SELECT *
FROM (SELECT ROW_.*, ROWNUM ROWNUM_
FROM (SELECT *
FROM TABLE1
WHERE TABLE1_ID = XX
ORDER BY GMT_CREATE DESC) ROW_
WHERE ROWNUM <= 20)
WHERE ROWNUM_ >= 10;