Oracle：
select * from (select * from tableName order by dbms_random.value) where rownum < NMS SQLServer：
select top N * from tableName order by newid()My Sql：
select * from tableName order by rand() limit N
Oracle：
select * from (select * from tableName order by dbms_random.value) where rownum < NMS SQLServer：
select top N * from tableName order by newid()My Sql：
select * from tableName order by rand() limit N
相关推荐
评论
