Oracle
子查询rownum
select t1.*
from
(
select rownum rnum,*
from
tableName
where
rownum <= 20
) t1
where t1.rnum > = 10
Oracle
子查询rownum
select t1.*
from
(
select rownum rnum,*
from
tableName
where
rownum <= 20
) t1
where t1.rnum > = 10