How to delete the Duplicate records in sql

Posted Date: 24 Jul 2008	Resource Type: Articles	Category: Databases
Author: Anne Grace	Member Level: Gold
Rating:	Points: 4

This sql sample shows how to delete duplicate records from a database table:


DELETE
FROM    test
WHERE    id not in
(
SELECT    MAX(id)
FROM        test
GROUP BY    c1, c2);

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Duplicate records . Delete duplicate records .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Clustered Index in SQL Server
	Previous Resource: How to sort the TEXT data type
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

Related Resources

Clustered Index in SQL Server
Database Constraints Part 2
Database Constraints Part 1
ANSI Joins
My experience of restoring database after deleting a transaction log file
Select dates of a day between two dates.