Mysql如何一次性查询总量和某个条件的数量并分组
AI 摘要salmon-ai
本文详细
教程
收到个需求,需要统计每个地区每个月的订单总量和某种条件下的数量,以下是示例sql:
sql
SELECT area,count(*) AS active_count,count(IF(mode=0,true,null)) AS buy_count FROM (
SELECT
r.id AS id,
CONCAT(rd.province," ",rd.city," ",rd.district) AS area,
r.mode AS mode
FROM `mix_rope_device_data` AS rd
LEFT JOIN mix_rope_device AS r ON rd.rope_id=r.id
WHERE r.create_time>='2023-06-01 00:00:00') AS a
GROUP BY area

用到的一些sql函数
- count(IF(条件,true,null)):满足条件返回true,计数,不满足则不参与计数;
- concat(字符串1,字符串2,字符串3...):拼接字符串。
评论
0 条—
还没有评论,来说第一句