delete from [GCPCore].[GCP.Product].[CityMall] where AreaID in(select AreaID from [GCPCore].[GCP.Product].[CityMall]
group by AreaID
having count(AreaID) > 1)
转载于:https://www.cnblogs.com/ButterflyEffect/p/6180026.html
delete from [GCPCore].[GCP.Product].[CityMall] where AreaID in(select AreaID from [GCPCore].[GCP.Product].[CityMall]
group by AreaID
having count(AreaID) > 1)
转载于:https://www.cnblogs.com/ButterflyEffect/p/6180026.html