Removing Duplicates

Information -> Source for Next Generation brcraju@hotmail.com

<< Overview of C# | Home | BizTalk Installation Requirements and sequence >>

Simple way to Remove Duplicate Rows from an Existing Table in SQL

SELECT DISTINCT *
INTO duplicate_table
FROM original_table
GROUP BY key_value
HAVING COUNT(key_value) > 1

DELETE original_table
WHERE key_value
IN (SELECT key_value
FROM duplicate_table)

INSERT original_table
SELECT *
FROM duplicate_table

DROP TABLE duplicate_table Posted on Thursday, October 23, 2003 10:47 AM SQLServer | Back to top

Comments on this post: Removing Duplicates

# re: Removing Duplicates

Nice. Had to insert individual columns into select and group clauses, but this did the trick. I might use a temp table in db's that support it. Thanks,

ZGrinch

Left by ZGrinch on Dec 10, 2003 10:01 PM

# re: Removing Duplicates