mysql 查询重复值命令

积累备忘啊:

select mtiId,IP,count(*) as count from t_maintenanceinfo group by IP having count>1; 

从t_maintenanceinfo表查询重复记录的mtiId 和ip字段,以及重复条数