我有一个包含重复多次的列serial_number的表。如何删除除第一个副本之外的整个行?通过下面的操作,我可以选择所有的副本。但无法删除。
SELECT serial_number, COUNT(*) FROM trademark_merge GROUP BY serial_number HAVING COUNT(*) > 1

发布于 2020-10-14 01:26:06
假设表的主键是id,您可以将其表述为delete/join查询,如下所示:
delete tm
from trademark_merge tm
inner join (
select serial_number, min(id) id
from trademark_merge
group by serial_number
) tm1 on tm.serial_number = tm1.serial_number and tm.id > tm1.idhttps://stackoverflow.com/questions/64339976
复制相似问题