将要分页的sql
SELECT id FROM cg_stage
对数据行计数编号(row_id)
SELECT TMP_PAGE.*, ROWNUMBER() OVER () AS ROW_ID FROM (
SELECT id FROM cg_stage
) TMP_PAGE
使用betwwen and 过滤row_id 分页
SELECT * FROM (
SELECT TMP_PAGE.*, ROWNUMBER() OVER () AS ROW_ID FROM (
SELECT id FROM cg_stage
) TMP_PAGE
) TMP_PAGE WHERE ROW_ID BETWEEN 10 AND 15