![]() |
|
sql隨機排序
作者: nnickk 日期: 2006-01-12 03:50
Randomize
Select TOP 5 [TestTitle] FROM [TestTable] orDER BY Rnd(-(自動編號欄位+"&Rnd()&"))
Select * FROM Northwind..Orders ORDER BY NEWID()
Select TOP 10 * FROM Northwind..Orders ORDER BY NEWID()
Select TOP 5 [TestTitle] FROM [TestTable] orDER BY Rnd(-(自動編號欄位+"&Rnd()&"))
Select * FROM Northwind..Orders ORDER BY NEWID()
Select TOP 10 * FROM Northwind..Orders ORDER BY NEWID()
廣告專區:
收入網摘
發表評論

訂閱
上一篇
返回
下一篇

