SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
WHERE ROWNUM <= Max(上届)
)
WHERE RN >= 21(下届)
优化点在于上届推送到内层循环,然后减小了数据集
Mysql:
select * from user where name like '%mm%' limit startrow,readsize;
其中值得推敲的是startrow和readsize也就是开始和读取的记录数
这样查询出来的结果集是从startrow行,读取endsize条记录,实际上查询到的结果集是
startrow+1到startrow+readsize的结果,
这是操作中我们应该注意的,结果集不包括startrow
Oracle: SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM &lt;= Max(上届))WHERE RN &gt;= 21(下届)优化点在于上届推送到内层循环,然后减小了数据集Mysql:select * from use...