从数据库表中随机获取N条记录的SQL语句
Oracle:
select * from (select * from tableName order by dbms_random.value) where rownum < N;
MS SQLServer:
select top N * from tableName order by newid();
My SQL:
select * from tableName order by rand() limit N;
转自：http://blog.csdn.net/senton/article/details/4404101
投递阿里巴巴集团等公司10个岗位 >