delete duplicate entries ina table

chiranjivip has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: delete duplicate entries ina table by Corion (Patriarch) on Jun 11, 2012 at 14:02 UTC
The sanest/"safest" approach would be to consult perlfaq4 and search for "duplicate". This involves unloading and reloading the (relevant) data from your table to a file. I also suggest creating a database (or table) backup and reviewing the data before any deletions are made in the table.	[reply]
Re: delete duplicate entries ina table by rovf (Priest) on Jun 11, 2012 at 14:31 UTC
You didn't say, what database you are using. Depending on that, perhaps the most efficient way would be to solve it within the database, instead of doing it with Perl. -- Ronald Fischer <ynnor@mm.st>	[reply] [d/l]
Re^2: delete duplicate entries ina table by chiranjivip (Initiate) on Jun 13, 2012 at 06:46 UTC
we are using sql developer as database,	[reply]
Re^3: delete duplicate entries ina table by rovf (Priest) on Jun 13, 2012 at 06:55 UTC
?????? Maybe I missed something, but I know "SQL Developer" only as an interface to control a database. -- Ronald Fischer <ynnor@mm.st>	[reply] [d/l]
Re: delete duplicate entries ina table by ww (Archbishop) on Jun 11, 2012 at 14:03 UTC
What have you tried? (ie, show us your code) If not "tried", what have you read? If neither of the above, for what have you searched, and how? Update: re the consideration, /me tries to disappear in embarassment. Should be `s/deleate/delete/;`. Oh, the chagrin!	[reply] [d/l]
A reply falls below the community's threshold of quality. You may see it by logging in.