数据库
(1)
收藏
我要回答
Oracle,随机查询查询语句-20 条
select * from (select * from 表名 order by dbms_random.value )where rownum <= 20;
MSSQL Server，随机查询语句-20 条
select top 20 * from 表名 order by newid()
MySQL:，随机查询语句-20 条
select * from 表名 order by rand() limit 20
Oracle,随机查询查询语句-20 条
select * from (select * from 表名 order by dbms_random.value )where rownum <= 20;
MSSQL Server，随机查询语句-20 条
select top 20 * from 表名 order by newid()
MySQL:，随机查询语句-20 条
select * from 表名 order by rand() limit 20