MySQL Forums
Forum List  »  Microsoft SQL Server

Re: How to delete duplicate records from a table?
Posted by: Armando Ortiz
Date: January 01, 2011 02:45PM

Delete from
table_name
where
(set conditions here)
limit 1

The "limit 1" will prevent the query from going beyond this threshold of results to delete.

You may want to backup the table in question before you go forward with this.

http://forums.mysql.com/read.php?21,135990,137776#msg-137776

Options: ReplyQuote


Subject
Written By
Posted
Re: How to delete duplicate records from a table?
January 01, 2011 02:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.