随机抽取记录问题

[hanbb1982]

比如我有个表，里面有个ID是从1至20，那么我随机抽取其中的10条记录出来，可以写
select top 10 id from 表 order by newid()
但如果我想在这些随机记录中必须包括有ID号为，1、2、3的记录，得如何写？

[SQL77]

select * from tb where id between 1 and 3 union all select * from (select top 7 * from tb where id >=4 order by newid())t

[SQL77]

引用 3 楼 SQL77 的回复:

select * from tb where id between 1 and 3 union all select * from (select top 7 * from tb where id >=4 order by newid())t

如果你1到3没有.可能就没有10条记录.按1楼改改

[daiyueqiang2045]

with cte
as
(
	select  id,newid() AS [newid]  表 where id in(1,2,3)
	union 
	select  top 10 id,newid() AS [newid] from 表 order by [newid]
)
SELECT * FROM 
from
cte 
order by id

[黄_瓜]

SELECT DISTINCT TOP 10 [id] FROM ( select id,newid() AS [newid] 表 where id in(1,2,3) union select top 10 id,newid() AS [newid] from 表 order by [newid] ) AS t

[专注or全面]

那你把这个三条查出来，再随机查询不包含这三条数据的七条出来

[u010618467]

[haitao]

引用 3 楼 SQL77 的回复:

select * from tb where id between 1 and 3 union all select * from (select top 7 * from tb where id >=4 order by newid())t

是这个 其他的相当于 那3个与随机的10个里 再随机选10个

[524929657雯]

[my_baby_2009]

3个PHP随机字符串函数生成器 你可以参考下，看有帮助不？！