美文网首页
删除重复数据,保留重复数据中最小id所在行的数据

删除重复数据,保留重复数据中最小id所在行的数据

作者: 海上笙明玥 | 来源:发表于2019-04-10 10:22 被阅读0次

delete from basis_family

where

number in (select snumber from (select number as snumber from basis_family group by number having count(number) > 1) a)

and

id not in (select sid from (select min(id) as sid from basis_family group by number having count(number) > 1 ) b)

相关文章

网友评论

      本文标题:删除重复数据,保留重复数据中最小id所在行的数据

      本文链接:https://www.haomeiwen.com/subject/ulngiqtx.html