select top 5 * into #tmp from tb where z_id=1 order by newid()insert into #tmp select top 5 * from tb where z_id=2 order by newid()select * from #tmp
select top 5 * from tb where z_id=1 union select top 5 * from tb where z_id=2 order by newid()
select * from( select top 5 *,[newid]=newid() from tb where z_id=1 order by [newid])a union all select * from( select top 5 *,[newid]=newid() from tb where z_id=2 order by [newid])a
set rowcount 5 select * into #tmp from tb where z_id=1 order by newid()insert into #tmp select * from tb where z_id=2 order by newid() insert into #tmp select * from tb where z_id=3 order by newid() ....set rowcount 0select * from #tmp order by newid()
select top 5 * into #tmp from tb where z_id=1 order by newid()insert into #tmp select top 5 * from tb where z_id=2 order by newid()select * from #tmp
union
select top 5 * from tb where z_id=2
order by newid()
select top 5 *,[newid]=newid() from tb where z_id=1 order by [newid])a
union all
select * from(
select top 5 *,[newid]=newid() from tb where z_id=2 order by [newid])a
select * into #tmp from tb where z_id=1 order by newid()insert into #tmp select * from tb where z_id=2 order by newid()
insert into #tmp select * from tb where z_id=3 order by newid()
....set rowcount 0select * from #tmp order by newid()