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

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

相关推荐