sql将随机数表分为多列

Question

这里是新的-但如果有任何帮助，我们将不胜感激我有一张有一列的表——这一列的数字从1到1000我想把这一列分成十列，这样我的新表中就会有10列和100行我也希望数字是随机顺序

任何帮助都将不胜感激——提前感谢

Answer 1

您可以使用条件聚合和row_number():

select max(case when seqnum % 10 = 0 then number end) as number_1,
max(case when seqnum % 10 = 1 then number end) as number_2,
. . .
max(case when seqnum % 10 = 9 then number end) as number_10
from (select t.*,
row_number() over (order by newid()) - 1 as seqnum
from t
) t
group by floor(seqnum / 10)