SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( select name,IDCARD from ys_zcl_canlian_renzheng WHERE 1 = 1 ) TMP_PAGE WHERE ROWNUM <= 2000400 ) WHERE ROW_ID > 2000000
这种分页数据往后面速度越慢
Oracle分页SQL
原文：https://www.cnblogs.com/hunmeng/p/12179854.html
