--查詢一條隨機(jī)數(shù)上來
select * from tablename where t_id=(select trunc(dbms_random.value(min(條件),max(條件))) from tablename;
select * from dept where did=(select trunc(dbms_random.value(min(rownum),max(rownum))) from dept);
--查詢N條隨機(jī)記錄上來
select * frmo (select * from tablename order by sys_guid()) where rownum<N
select * from (select * from dept order by sys_guid()) where rownum < 5;
--查詢出表中X條中從N到M條特定記錄上來（分頁查詢）
select * from (select rownum r,t.* from tablename t where rownum<X) ss where ss.r>N and ss.r <=M
select * from (select rownum r, t.* from dept t where rownum<6) ss where ss.r > 2 and ss.r <= 10