随机抓取数据

MsSql  随机取数据 select top 10 * from TableName order by newid()
Access 随机取数据 select  SELECT top 10 id FROM 表1 order by rnd(id)
mySql  随机取数据 SELECT id FROM gueze order by rand() limit 10

posted @ 2011-11-25 14:43  hen  阅读(239)  评论(0编辑  收藏  举报