How to remove duplicate rows in SQL Server 2008 when no key is present

Wendelius

Rate me:

4.95/5 (12 votes)

20 Feb 2011CPOL

107.4K

This tip describes how to delete duplicate rows from a table that doesn't have a key.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. How to remove duplicate rows in SQL Server 2008 when no key is present

2 Sep 2011Ron sikander

Find out the number of duplicates in the table:select count(*), VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC from TR00.NV_STARTER_INDEXgroup by VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC having count(*)>1--- Delele them using following statementDELETEFROM TR00.NV_STARTER_INDEXWHERE...

SQL

SQL-Server-2008

SQL-Server