查询重复记录

#查询省份相同的用户
select id,uname,group_id,province_id,city_id,county_id from user  
province_id in (select province_id from user group by province_id having count(province_id) > 1)
ORDER BY `user`.`province_id` ASC