sql随机排序

Order By Rnd()

Order By NewID()  ‘此句在sql2000中试好用

Select * From table Order By Rnd(ID)

SELECT * FROM table ORDER BY Rnd(ID-timer())

posted @ 2011-04-18 15:11  海乐学习  阅读(6726)  评论(0编辑  收藏  举报