删除重复数据只保留一条
--删除重复数据
DELETE FROM SXLQ_SupplierInfo WHERE ID NOT IN (SELECT MIN(ID) FROM SXLQ_SupplierInfo GROUP BY SupplierID)
--删除重复数据
DELETE FROM SXLQ_SupplierInfo WHERE ID NOT IN (SELECT MIN(ID) FROM SXLQ_SupplierInfo GROUP BY SupplierID)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。