Avatar of breeze351

asked on 

Need to delete duplicate records

I was having problems with a table and I realized that there are some duplicate records that need to be deleted.
How do I do this if they are exact copies?

NY1S05000010 |1001             |10       |Spring Street
NY1S05000010 |1001             |10       |Spring Street

I need to get rid of the 2nd one.  The dupes are not all over the file.  In other words, It only happens occasionally.
How it happened is beyond me.

Is there a quick script that I could write to get rid of these?
Microsoft SQL Server

Avatar of undefined
Last Comment
Mark Wills

8/22/2022 - Mon