SELECT sex, COUNT(Case province when '广东省' then '广东省' end) as '广东省', COUNT(Case province when '江西省' then '江西省' end) as '江西省', COUNT(Case province when '浙江省' then '浙江省' end) as '浙江省' From Case_Test2 group by sex
SELECT sex, COUNT(Case province when '广东省' then '广东省' end) as '广东省', COUNT(Case province when '江西省' then '江西省' end) as '江西省', COUNT(Case province when '浙江省' then '浙江省' end) as '浙江省' From Case_Test2 group by sex
转载于:https://www.cnblogs.com/JiangXiaoTian/articles/2484425.html