按某几列删除表中重复数据
- WBOY原創
- 2016-06-07 14:53:341128瀏覽
按某几列删除表中重复数据 开始获取了重复列的数据，想了好久不知道怎么在那基础上删除，最后仔细一想，通过下面那个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)
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn