求个合并行的SQL

[夜色镇歌]

Table1：列 CA CB CC CC1，下面两条记录

CA CB CC CC1
------------------------------
AAA BB - 3
AAA BB 4 -


如何得到这样的记录
CA CB CC CC1
-------------------------------
AAA BB 4 3

[xdashewan]

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