mysql筛选出重复数据,mysql 如何筛选重复的数据

筛选重复数据 -------------单列-----------------------SELECT 检查字段, COUNT(检查字段)FROMtable_nameGROUP BY 检查字段HAVING COUNT(检查字段) > 1-------------多列------------------SELECT 检查字段1, COUNT(检查字段1),检查字段2, COUNT(检查字段2),...FROMtable_nameGROUP BY 检查字段1, 检查字段2, ...HAVING (COUNT(检查字段1) > 1) AND (COUNT(检查字段2) > 1) AND

如：

SELECT activity_id, COUNT(activity_id),user_id, COUNT(user_id),gmt_activity, COUNT(gmt_activity),classes_type, COUNT(classes_type),gmt_create, COUNT(gmt_create),gmt_modified, COUNT(gmt_modified),state, COUNT(state),is_deal, COUNT(is_deal)FROMactivity_user GROUP BY activity_id, user_id,gmt_activity,classes_type,gmt_create,gmt_modified,state,is_dealHAVING (COUNT(activity_id) > 1) AND (COUNT(user_id) > 1) AND (COUNT(gmt_activity) > 1) AND (COUNT(classes_type) > 1) AND (COUNT(gmt_create) > 1) AND (COUNT(gmt_modified) > 1) AND (COUNT(state) > 1) AND (COUNT(is_deal) > 1)