两列数据合并到一列中

[drik]

我的表有三列，我想将其中两列数据合并到一列中
例
A B C
a 1 31
b 2 32
a 3 33
以此类推
我想得到如下结果
D列
a
b
c
1
2
3
如何写这个SQL语句,谢谢

[dawugui]

select a from tb
union all
select b from tb

[天-笑]

select a ,b, c ,a as d  from table
union all
select a ,b, c ,b as d  from table

[liangCK]

SELECT A FROM tb
UNION ALL
SELECT RTRIM(B) FROM tb

[dawugui]

create table tb(A varchar(10), B varchar(10), C int)
insert into tb values('a' , '1' , 31 )
insert into tb values('b' , '2' , 32 ) 
insert into tb values('a' , '3' , 33 )
go

select a d from tb
union all
select b d from tb

drop table tb


/*
d          
---------- 
a
b
a
1
2
3
*/

[dawugui]

--如果类型不一样,都转换为varchar

create table tb(A varchar(10), B int, C int)
insert into tb values('a' , 1 , 31 )
insert into tb values('b' , 2 , 32 ) 
insert into tb values('a' , 3 , 33 )
go

select cast(a as varchar) d from tb
union all
select cast(b as varchar) d from tb

drop table tb


/*
d          
---------- 
a
b
a
1
2
3
*/

[肥龙上天]

[Quote=引用楼主 drik 的帖子:]
我的表有三列，我想将其中两列数据合并到一列中
例
A B C
a 1 31
b 2 32
a 3 33
以此类推
我想得到如下结果
D列
a
b
c
1
2
3
如何写这个SQL语句,谢谢
[/Quote]

create table #1(A varchar(10), B int, C int)
insert into #1 values('a' , 1 , 31 )
insert into #1 values('b' , 2 , 32 ) 
insert into #1 values('a' , 3 , 33 )
go
-----如果列中不能包含重复值
select rtrim(a) D from #1
union 
select rtrim(b) from #1
/*
D
------------
1
2
3
a
b

(5 row(s) affected)

*/

------如果列中可以包含重复值
select rtrim(a) D from #1
union all
select rtrim(b) from #1
/*
D
------------
a
b
a
1
2
3

(6 row(s) affected)
*/

[yuyangyangde]

create table A(a1 varchar(20),a2 varchar(20))
insert into A values('a','1')
insert into A values('b','2')
insert into A values('c','3')



create Table B(B1 varchar(20))
insert into B
select a1
from A
insert into B
select a2
from A
select * from B


--
a
b
c
1
2
3

[kye_jufei]

create table tb(A varchar(10), B int, C int)
insert into tb values('a' , 1 , 31 )
insert into tb values('b' , 2 , 32 ) 
insert into tb values('a' , 3 , 33 )
go

select cast(a as varchar) d from tb
union all
select cast(b as varchar) d from tb

drop table tb


/*
d          
---------- 
a
b
a
1
2
3
*/

[Veronika]

还要求回帖，只能回帖之后再看看