數據清理——刪除多個欄位重覆的記錄

資料庫內容，隨機編了一些數據，其中認為兩個欄位Name、Address1一致為重覆記錄，保留其中一條

1. 刪除兩個欄位Name、Address1一致重覆的記錄，保留一條：
   • 找出

select * from tableabc
where Name in( select Name from tableabc group by Name, Address1 having count(Name) > 1)

• • 刪除

1 select * from tableabc 
2 where Name in( select Name from tableabc group by Name, Address1 having count(Name) > 1)
3   and 
4 ID not in(select max(ID) from [mibox].[dbo].[Puzzle] group by Name,Address1 having count(puzzleface) > 1 )

　　2.