--创建需要删除重复数据的视图
CREATE VIEW M_Tabs_GoodsStuff_view_Del AS
SELECT
ROW_NUMBER() OVER (PARTITION BY GoodsID,ColorID ORDER BY (SELECT 1) ) AS no,
GoodsID,ColorID
FROM M_Tabs_GoodsStuff
--删除多余的数据
DELETE FROM M_Tabs_GoodsStuff_view_Del WHERE no != 1
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。