select * from table sample(xx) where ....xx为一个[0.000001-100)的百分比.
1. select * from (select * from your_table order by sys_guid()) where rownum <= 100; 2. http://expert.csdn.net/Expert/topic/2169/2169173.xml?temp=.6450159
select * from ( select p.*, rownum rnum from (select * Table ) p where rownum < MAX ) where rnum >= MIN
select * from
(select * from your_table order by sys_guid()) where rownum <= 100;
2.
http://expert.csdn.net/Expert/topic/2169/2169173.xml?temp=.6450159
select * from (
select p.*, rownum rnum
from (select * Table ) p
where rownum < MAX
) where rnum >= MIN