----------------
select * from adminrole where rownum<=4
minus
select * from adminrole where rownum<2>
select * from
(select rownum row_id ,b.* from (select a.* from sorttable a order by sortid)b)
where row_id between 5 and 9;