select B.simno from (select distinct top 10 simno,newid() as id from award order by newid()) B
select top 2 a.* from (select simno from award group by simno having count(*)=1) a order by newid()
libin_ftsafe(子陌红尘) select top 2 * from (select distinct(simno) from award) order by newid() 改成 select top 2 from (select distinct(simno) from award) as b order by newid() 就可以了
(select distinct top 10 simno,newid() as id from award order by newid()) B
select top 2 * from (select distinct(simno) from award) order by newid()
改成
select top 2 from (select distinct(simno) from award) as b order by newid()
就可以了