问题:sql语句怎么一次选出5条随机且不重复的记录

select top 5 * from (select distinct * from Tablename) a order by newid()

select distinct top 5 * from table

j9988的不错，select distinct top 5 * from table只能取前5条记录。

to：
PFPF
不过不可以
试了么？好像不行耶
出错
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

要不用这个 ：）多了一列
select distinct top 3 *,newid() from dis order by newid()