declare @T table(name varchar(10),sex varchar(10),old int,sbsl int) insert into @T select 11 , '男' , 13 , 12 union all select 22 , '女' , 12 , 12 union all select 33 , '女' , 12 , 12 union all select 44 , '女' , 12 , 12select sex,sum(sbsl) as sbsl from @t group by sex
select sex,sum(sbsl) as [count] from 表名 group by sex
insert into @T select 11 , '男' , 13 , 12
union all select 22 , '女' , 12 , 12
union all select 33 , '女' , 12 , 12
union all select 44 , '女' , 12 , 12select sex,sum(sbsl) as sbsl from @t group by sex