SQLSoldier Oct 26th, 2015 127 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- Delete T1
- From dbo.MyTable As T1
- Inner Join dbo.MyTable As T2 On T2.AcctNumber = T1.AcctNumber
- Where T1.ID < T2.ID;
RAW Paste Data