sql 随机取数

Sql server:
      select top 10 * from 表 order by newid()
Access:
      SELECT top 10 * FROM 表 ORDER BY Rnd(id)
MySql:
     Select * From 表 Order By rand() Limit 10

posted @ 2014-01-18 19:05  jason&li  阅读(397)  评论(0编辑  收藏  举报