求个合并行的SQL解决方案
求个合并行的SQL
Table1：列 CA CB CC CC1，下面两条记录
CA CB CC CC1
------------------------------
AAA BB - 3
AAA BB 4 -
如何得到这样的记录
CA CB CC CC1
-------------------------------
AAA BB 4 3
------解决思路----------------------
------解决思路----------------------
Table1：列 CA CB CC CC1，下面两条记录
CA CB CC CC1
------------------------------
AAA BB - 3
AAA BB 4 -
如何得到这样的记录
CA CB CC CC1
-------------------------------
AAA BB 4 3
------解决思路----------------------
select CA, CB, max(CC) as CC, max(CC1) as CC1
from Table1
group by CA, CB
------解决思路----------------------
;with tbl(CA,CB,CC,CD) as
(
select 'AAA','BB','-','3' union all
select 'AAA','BB','4','-'
)
select ca,cb,max(cc) as cc,max(cd) as cd from tbl group by ca,cb
ca cb cc cd
AAA BB 4 3