SELECT `sp_id`,`sp_name`,`sp_model` FROM `sp` where `sp_type`=1 and `com_net`=0 order by rand() limit 20 这个是MYSQL
select top 10 * from oblog_user order by newid() 这个是MSSQL
SELECT `sp_id`,`sp_name`,`sp_model` FROM `sp` where `sp_type`=1 and `com_net`=0 order by rand() limit 20 这个是MYSQL
select top 10 * from oblog_user order by newid() 这个是MSSQL
转载于:https://www.cnblogs.com/subendong/archive/2013/01/17/2864877.html