在1到17条随机选取记录:
select a.* from (select rownum rn,a.* from t_jg a)a where rn=(select round(dbms_random.value(1,17)) rn from dual);随机选出(在1到17条范围内,一条没有,一条,多条)记录
select a.* from (select rownum rn,a.* from t_jg a)a where rn=round(dbms_random.value(1,17));
select a.* from (select rownum rn,a.* from t_jg a)a where rn=(select round(dbms_random.value(1,17)) rn from dual);随机选出(在1到17条范围内,一条没有,一条,多条)记录
select a.* from (select rownum rn,a.* from t_jg a)a where rn=round(dbms_random.value(1,17));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货