哼哼小虾米

摘要： SQL Server：Select TOP N * From TABLE Order By NewID()view plaincopy to clipboardprint?Select TOP N * From TABLE Order By NewID()Select TOP N * From TABLE Order By NewID()NewID()函数将创建一个 uniqueidentifier 类型的唯一值。上面的语句实现效果是从Table中随机读取N条记录。Access：Select TOP N * From TABLE Order By Rnd(ID)view plaincopy t 阅读全文