用ROWNUM,取表的某段值: select * from (select rownum r,name from table where rownum<10 order by r) where r>5;