2010-01-14 17:36:05j69

sql指令,隨機讀取N筆記錄的方法

Sql server:select top n * from 資料表 order by newid()
Access:Select top n * FROM 資料表 orDER BY Rnd(id)
mysql:Select * From 資料表 order By rand() Limit n