Find the result of the result set!

eebb2002

If I get the corresponding ten data from the selection in a table, the second time I want to randomly take five data from the result of the first result set, I wonder how to write it like this, is there a function! ?? Thank you guys!

prajna

select top 5 * from (select * from table) t order by newid ()

michealhenry

select top 5 *
from
(Your query) tt
order by newid ()

fanfan1980

use pubs
go
select top 5 * from
(
select top 10 title_id from titles
) a order by newid ()

eebb2002

The top 5 can only take the first five, if it can be repeated ... how to write a statement !?

michealhenry

You can also modify your query directly

select top 5 ...
from a, b, c ...
where ...
order by newid ()

我是杀人狂

Add this order by newid ()
It's just random ...

prajna

Similarly top 1 five times and then union all

imapiggy

select top 5 * from
(
select top 10 * from tbname
t order by newid ()