Oracle随机选择一条记录SQL
Oracle随机选择一条记录SQL:
SELECT * FROM (SELECT * FROM t_enterprise_info order by dbms_random.value) WHERE rownum =1
posted on 2016-09-03 16:35 xusweeter 阅读(4473) 评论(0) 编辑 收藏 举报
千日修以返初心 万日炼以达极致
Oracle随机选择一条记录SQL:
SELECT * FROM (SELECT * FROM t_enterprise_info order by dbms_random.value) WHERE rownum =1
posted on 2016-09-03 16:35 xusweeter 阅读(4473) 评论(0) 编辑 收藏 举报
