oracle sql或者存储过程分页大家都没少听吧,通过rownum,查找rownum的行数进行分页
select * from (select selectSec.*, rownum rownumType
from (select * from tableName) selectSec
WHERE ROWNUM <= 50000)
WHERE rownumType > 100
oracle sql或者存储过程分页大家都没少听吧,通过rownum,查找rownum的行数进行分页
select * from (select selectSec.*, rownum rownumType
from (select * from tableName) selectSec
WHERE ROWNUM <= 50000)
WHERE rownumType > 100