你的字段名也太长了吧,我简化一下,语句是这样的:select case when GROUPING(VECN)==1 then '合计' else VECN end as VECN,case when GROUPING(VCN)==1 then '合计' else VCN end as VCN,SUM(case CLS when 'S' then 1 else 0 end) as S,SUM(case CLS when 'S' then 1 else 0 end) as Gfrom table group by VECN,VCN with rollup运行结果:中州大学 国际贸易 1 1 中州大学 合计 1 1