区间 select * from (select rownum id,tbname.* from tbname where rownum<20) where id>10; 排序 select * from (select * from tbname order by colname) where rownum<=10;select * from (select rownum id,t.* from (select * from tbname order by colname) t where rownum<20) where id >10;
select * from (select rownum id,tbname.* from tbname where rownum<20)
where id>10;
排序
select * from (select * from tbname order by colname)
where rownum<=10;select * from (select rownum id,t.* from (select * from tbname order by colname) t
where rownum<20)
where id >10;