mysql 如何去重

 

#去重保留最大ID
DELETE FROM  test  WHERE id 
 in (
select y.id from (

	select b.id 
		from test t 
		join  
			(  select name,count(*) as cc,min(id) as id 
					from test  
						GROUP BY name 
						HAVING cc >1
			) b 
		on t.id = b.id
							
					) y

) ;