苗景云的博客

select top 1 * from table order by newid()

top后面的数字就是你要随即搜索出来几条数据，这个方法只适用sql server

--------------------------------------------------------------------------------------------------------

SELECT top 4 * FROM 表 ORDER BY Rnd(id)
...