mysql 去重汇总：统计去重后的下单总人数

mysql 去重汇总：统计去重后的下单总人数

mysql count group by统计条数方法

mysql 分组之后如何统计记录条数? gourp by 之后的 count，把group by查询结果当成一个表再count一次
select count() as count from
(SELECT count() FROM 表名 WHERE 条件 GROUP BY id ) a;

sql demo

SELECT count(*) as total FROM (SELECT count(*) FROM order_list WHERE  pay_time>1603814400 AND pay_time<1603900800 GROUP BY user_id) u;