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