mysql 查询重复值命令

     积累备忘啊:

     

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

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