MySQL查询多行重复数据SQL
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