select 外服名称,缴费月份,sum(社保基数) as 社保基数之和from 表1group by 外服名称,缴费月份
select [外服名称],[缴费月份],sum(ISNULL([社保基数],0)) AS [社保基数之和] from [表名] group by [外服名称],[缴费月份]
SELECT 外服名称,缴费月份,sum(社保基数) AS 社保基数之和 FROM 表1 GROUP BY 外服名称,缴费月份