从数据库表中获取一条随机数据:
Oracle:
select * from (select * from table order by dbms_random.value) WHERE rownum = 1
SqlServer:
select top 1 * from table order by newid()
MySql:
select * from table order by rand() limit 1
从数据库表中获取一条随机数据:
Oracle:
select * from (select * from table order by dbms_random.value) WHERE rownum = 1
SqlServer:
select top 1 * from table order by newid()
MySql:
select * from table order by rand() limit 1