删除表中重复数据「建议收藏」

delete from yyd_wykl_goodsInfo
   
where skuId in (select skuId from (select skuId from yyd_wykl_goodsInfo group by skuId having count(skuId) > 1) a)
 
and id not in ( select id from (select min(id) as id  from yyd_wykl_goodsInfo group by skuId having count(skuId )>1) b);

select * from yyd_wykl_goodsInfo as s
where s.id,s.title in (select id,title from yyd_wykl_goodsInfo group by id,name  having count(id)>1) 
and s.id not in ( select min(id) as id  from yyd_wykl_goodsInfo group by id,name having count(id )>1);

select * from user
where userId in (select  userId from  usergroup  by  peopleId  having  count(userId) > 1)

select * from user a
where (a.userId,a.name) in  (select userId,name from user group by userId,name having count(*) > 1)