sql server的随机函数newID()和RAND() SELECT * FROM Northwind..Orders ORDER BY NEWID() --随机排序 SELECT TOP 10 * FROM Northwind..Orders ORDER BY NEWID() --从Orders表中随机取出10条记录
转载于:https://www.cnblogs.com/vibratea/archive/2010/09/16/1827711.html