1、接随机顺序排序
select name from table1 where job = "student" order by dbms_random.random
2、取接随机顺序排序的前 100 条
select (select t.name,rownum
from table1 t
where job = "student" order by dbms_random.random)
where rownum < 100
2、取接随机顺序排序的 100 ~ 200 条
select (select t.name,rownum
from table1 t
where job = "student" order by dbms_random.random)
where rownum between (100,200)
select name from table1 where job = "student" order by dbms_random.random
2、取接随机顺序排序的前 100 条
select (select t.name,rownum
from table1 t
where job = "student" order by dbms_random.random)
where rownum < 100
2、取接随机顺序排序的 100 ~ 200 条
select (select t.name,rownum
from table1 t
where job = "student" order by dbms_random.random)
where rownum between (100,200)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货