将相同数据的数量合并的sql

select XMMC, XMBH, HTBH, CLLB, CLMC, GGXH, PP, DW, sum(convert(int,[SL])) as c from O_Project_CLBG where 1=1