 |
|
訂閱
上一篇
返回
下一篇
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()
引用通告地址:
點擊獲取引用地址
廣告專區：
收入網摘
發表評論
