select Site,sum(case when type='item01' then 1 else 0 end) as item01, sum(case when type=item02' then 1 else 0 end) as item02, sum(case when type='item03' then 1 else 0 end) as item03,count(*) as SubTotal from Table group by site
说明:
用于汇总统计各个SITE的ITEM01/02/03的数量
转载于:https://blog.51cto.com/mengping/1545581