将一列数据拆成两列

[yubofighting]

a
1
2
3
4


现在要将a列拆成b,c两列

b c
1 3

2

4

[yubofighting]

[Quote=引用 1 楼 acherat 的回复:]
拆分的依据是什么？
[/Quote]

有id标志的

[AcHerat]

楼主你的问题没有描述清楚！你要说明b列和c列是怎么取值的！

[yubofighting]

[Quote=引用 5 楼 acherat 的回复:]
楼主你的问题没有描述清楚！你要说明b列和c列是怎么取值的！
[/Quote]

有一个标志列，与a列对应

比如：
a id
1 0
2 1
3 0
4 1

同一个表中将id为1的变为b列，将id为0的变为c列

如果两列行数不一样，少的那列用null补足

[syhxj]

case when就可以实现

[百年树人]

select a.a as b,b.a as c
from
(select rn=row_number() over(order by getdate()),a from tb where id=0) a
full join
(select rn=row_number() over(order by getdate()),a from tb where id=1) b
on a.rn=b.rn

[--小F--]

select
   max(case id when 1 then a else '' end ) as b,
   max(case id when 0 then a else '' end ) as c
from
   tb

[AcHerat]

create table tb(a int,id int)
insert into tb
select 1,0 union all
select 2,1 union all
select 3,0 union all
select 4,1 union all
select 5,0
go

select a.a,b.a
from (select a,id as b from tb where id = 0)a
      full join
     (select a,id as c from tb where id = 1)b
	  on a.a + 1 = b.a

drop table tb

/*
a           a
----------- -----------
1           2
3           4
5           NULL

(3 行受影响)

[gw6328]

[Quote=引用 8 楼 josy 的回复:]
SQL code
select a.a as b,b.a as c
from
(select rn=row_number() over(order by getdate()),a from tb where id=0) a
full join
(select rn=row_number() over(order by getdate()),a from tb where id=1) b
……
[/Quote]
up.
楼主分的时候行的对应关系应该要注意一下。

[feixianxxx]

[Quote=引用 8 楼 josy 的回复:]

SQL code
select a.a as b,b.a as c
from
(select rn=row_number() over(order by getdate()),a from tb where id=0) a
full join
(select rn=row_number() over(order by getdate()),a from tb where id=1) b
on ……
[/Quote]
...树哥 很久不见你答题...

[AcHerat]

拆分的依据是什么？

[Xiao_Ai_Mei]

什么规律啊，？？？？？？？？？？？？？？？？？？

[jayjiang0910]

不明白LZ的意思