需要对一个表二维统计的情况下下需要对多个条件groupby 可以把条件放在count 里用case when区分,暂时只统计两个条件的,多的还没试;
SELECT
COUNT
(CASE WHEN gender='F' THEN id ELSE null END ) AS F,
COUNT
(CASE WHEN gender='M' THEN id ELSE null END ) AS M,
countyName
FROM
VOTER
GROUP BY
countyName;
需要对一个表二维统计的情况下下需要对多个条件groupby 可以把条件放在count 里用case when区分,暂时只统计两个条件的,多的还没试;
SELECT
COUNT
(CASE WHEN gender='F' THEN id ELSE null END ) AS F,
COUNT
(CASE WHEN gender='M' THEN id ELSE null END ) AS M,
countyName
FROM
VOTER
GROUP BY
countyName;