1 详见如下
SELECT day_time,`city_code`,count(1) as num
FROM t_user_register_analyse GROUP BY `day_time`,city_code having num >1
1 详见如下
SELECT day_time,`city_code`,count(1) as num
FROM t_user_register_analyse GROUP BY `day_time`,city_code having num >1
转载于:https://www.cnblogs.com/QuestionsZhang/p/11271753.html