SELECT
SUM(CASE WHEN a.position = '10' THEN 1 ELSE 0 END) AS position10,
SUM(CASE WHEN a.position = '20' THEN 1 ELSE 0 END) AS position20,
SUM(CASE WHEN a.position = '30' THEN 1 ELSE 0 END) AS position30,
SUM(CASE WHEN a.position = '40' THEN 1 ELSE 0 END) AS position40,
SUM(CASE WHEN a.position = '99' THEN 1 ELSE 0 END) AS position99
FROM biz_contact a
WHERE a.customer_id = #{customerId}
mybatis 统计一个字段各个种类数据
最新推荐文章于 2023-02-15 11:58:45 发布