MS SqlServer 随机查询并随机排序

码农 2115

MS SqlServer : 

select top N * from Table1 order by NewId()

MySql: 

SELECT * FROM tableName ORDER BY rand()
—— 完 ——