Delete T1
From dbo.MyTable As T1
Inner Join dbo.MyTable As T2 On T2.AcctNumber = T1.AcctNumber
Where T1.ID < T2.ID;