MySQL做数据统计

案例一：统计任务完成和未完成的数量

SELECT
CASE
    WC WHEN '0' THEN '完成' ELSE '未完成' END AS name,
    COUNT( ID ) AS value
FROM
    l_rwgl_rwjl 
WHERE
    is_deleted = 0 
    AND WC IS NOT NULL 
GROUP BY
    WC

image.png

案例二：按照任务地点统计任务完成和未完成的情况

SELECT
    rwdd 'missionPlace',
    ifnull( SUM( CASE WHEN WC = 0 THEN 1 ELSE 0 END ), 0 ) 'finished',
    ifnull( SUM( CASE WHEN WC = 1 THEN 1 ELSE 0 END ), 0 ) 'unFinished' 
FROM
    l_rwgl_rwjl 
WHERE
    is_deleted = 0 
    AND rwdd IN ( SELECT rwdd FROM l_rwgl_rwjl ) 
GROUP BY
    RWDD

image.png

持续更新...