这个sql语句怎么写？ 急。。。等

[xjis00]

我有个表A 3列 a, b, c 其中a 是日期型， b,c 都是数字
例如原来数据为
2003-10-30 10 20
2003-10-31 25 29

现在变为
2003-10-30 10
2003-10-30 20
2003-10-31 25
2003-10-31 29

应该怎么写此sql语句？

[songzj8]

select a,b from A
union
(select a,c from A)
这样就OK了

[qiyousyc]

select a,b from A
union all
select a,c from A

[songzj8]

竟然和我一样

[xjis00]

不好意思 我在问一个 若我要反过来怎么写？
2003-10-30 10
2003-10-30 20
2003-10-31 25
2003-10-31 29
现在变为
2003-10-30 10 20
2003-10-31 25 29

[songzj8]

select A1.a,A1.b ,A2.b
from A A1,A A2
where A1.a=A2.a and A1.b<>A2.b

[njjianguogu]

create table A (a datetime,b int,c int)
insert A values ('2003-10-30', 10 , 20)
insert A values('2003-10-31', 25, 29)
select a,b from A union (select a,c from A)
--(影響 4 個資料列)
2003-10-30 00:00:00.000 10
2003-10-30 00:00:00.000 20
2003-10-31 00:00:00.000 25
2003-10-31 00:00:00.000 29

[njjianguogu]

--反過來：
select A.b ,(select A.a,min(A.b) b from A group by A.a) from A

[njjianguogu]

select A.b ,(select A.a,min(A.b) b from A group by A.a) c from A

[dotnba]

:)