SELECT
no,
COUNT(1) AS all_num,
COUNT(CASE WHEN is_com = 1 THEN is_com END) AS com_num,
COUNT(CASE WHEN is_com = 0 THEN is_com END) AS not_com_num
FROM
data a
WHERE 1=1
GROUP BY no
mysql count() 条件语句
最新推荐文章于 2024-06-17 00:09:10 发布