I LOVE YOU 韩鹏鹏

oracle随机取number条满足条件的数据

select id
from T_CLOUD_BUY_NUMBER m
where m.act_id = #{actId}
and nvl(m.user_id, 0) = 0
order by dbms_random.value)
where rownum <= #{number}

posted @ 2017-06-02 16:26  韩鹏鹏  阅读(459)  评论(0编辑  收藏  举报