删除重复数据只保留一条

--删除重复数据
  DELETE FROM SXLQ_SupplierInfo WHERE ID NOT IN (SELECT MIN(ID) FROM SXLQ_SupplierInfo GROUP BY SupplierID)
posted @ 2024-03-15 16:47  放飞梦想  阅读(2)  评论(0)  编辑  收藏  举报