考虑到您具有标识或其他任何可以识别订单的列
样本数据
create table test_tab
(id int identity(1,1), sophong int)
insert into test_tab values (7)
insert into test_tab values (4)
insert into test_tab values (11)
insert into test_tab values (7)
insert into test_tab values (4)
insert into test_tab values (11)
insert into test_tab values (6)
insert into test_tab values (3)
insert into test_tab values (11)
询问 :
;WITH cte as
(
SELECT *,((ROW_NUMBER() over(order by id)-1)/3)+1 as iden,
((ROW_NUMBER() over(order by id)-1)%3)+1 as ident
FROM test_tab
)
SELECT max(case when iden = 1 then sophong end) as [1],
max(case when iden =2 then sophong end) as [2],
max(case when iden = 3 then sophong end) as [3]
FROM cte
group by ident
结果:
1 |2 |3
----+---+---
7 |7 |6
4 |4 |3
11 |11 |11
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句