欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

按某几列删除表中重复数据

程序员文章站 2022-06-07 15:20:52
...

按某几列删除表中重复数据 开始获取了重复列的数据,想了好久不知道怎么在那基础上删除,最后仔细一想,通过下面那个sql多执行几次知道执行结果为0就表示重复数据已经删除了撒 www.2cto.com delete from warehouse_summary t where t.summary_id in ( select


按某几列删除表中重复数据

开始获取了重复列的数据,想了好久不知道怎么在那基础上删除,最后仔细一想,通过下面那个sql多执行几次知道执行结果为0就表示重复数据已经删除了撒

www.2cto.com

delete from warehouse_summary t where t.summary_id in (

select min(t.summary_id)

from warehouse_summary t

left join warehouse_Info wi

on t.warehouse_id = wi.warehouseid

where

t.status = 1 group by wi.warehouseid,t.product_id having count(*)>1

)

delete from people

where peopleId in (select peopleId from people group by peopleId

having count(peopleId) > 1)

and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)