Oracle分页SQL

 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

这种分页数据往后面速度越慢

posted @ 2020-01-11 14:37  海角的远方  阅读(252)  评论(0编辑  收藏  举报