求一个关于分组的sql语句，在线等啊~~~~~~~~~~~

[xujun5031]

如上图所示，要根据city、status进行分组统计，并同时要计算num的和，求大神帮忙哈

[唐诗三百首]

select city,
           status,
           'num'=sum(num) 
 from [表名]
 group by city,status

[Yole]

看您这结果，和name列没啥关系啊~ 直接city和status分组就可以了。

[Pact_Alice]

select city,status,sum(num)as sum(num)from tablea group by city,status

[wanghan226]

select city,status,sum(num) as 合计值 from tablea group by city,status

[卖水果的net]

-- 凑个人数，建议分组完后，加一个 order by 语句

-- 借楼上几位的代码 

select city,status,sum(num) as 合计值 
from tablea  
group by city,status
order by city,status -- 加上这句