怎样在一个结果集中随机查询中其中的两条记录？

[pingban_1]

字段NAME，结果集是单位A，单位B，单位C。。。。单位N，我想每次查询的时候只随机查询出两条记录，怎么做？

[發糞塗牆]

select top 2 * from 结果集 order by checksum(newid())

[發糞塗牆]

我觉得你最好给点测试数据，你的描述貌似有点太简单了

[pingban_1]

create table test1 ( name varchar(50) ) insert into test1 select '单位A' insert into test1 select '单位B' insert into test1 select '单位C' insert into test1 select '单位D' insert into test1 select '单位E' insert into test1 select '单位F' insert into test1 select '单位G' insert into test1 select '单位H' insert into test1 select '单位I' insert into test1 select '单位J' insert into test1 select '单位K' select top 2 * from test1 order by checksum(newid()) drop table test1

[發糞塗牆]

引用 3 楼 pingban_1 的回复:

create table test1 ( name varchar(50) ) insert into test1 select '单位A' insert into test1 select '单位B' insert into test1 select '单位C' insert into test1 select '单位D' insert into test1 select '单位E' insert into test1 select '单位F' insert into test1 select '单位G' insert into test1 select '单位H' insert into test1 select '单位I' insert into test1 select '单位J' insert into test1 select '单位K' select top 2 * from test1 order by checksum(newid()) drop table test1

你这样写满足你要求没？