Home » SQL & PL/SQL » SQL & PL/SQL » DELETION OF DUPLICATE RECORDS
DELETION OF DUPLICATE RECORDS [message #276386] Thu, 25 October 2007 01:24 Go to next message
sonalshastry
Messages: 52
Registered: September 2007
Member
Hi all

i have atable with 2 column, no primary key, no index but the data n that table is wrongly inserted twice now I wants to delete duplicate row from this table

can someone give me some logic or query

please help

sonal

[Updated on: Thu, 25 October 2007 01:25]

Report message to a moderator

Re: DELETION OF DUPLICATE RECORDS [message #276389 is a reply to message #276386] Thu, 25 October 2007 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you google for this very often asked question?

Regards
Michel
Re: DELETION OF DUPLICATE RECORDS [message #276391 is a reply to message #276386] Thu, 25 October 2007 01:30 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Pick a thread and start reading here.

MHE
Previous Topic: Merge performance
Next Topic: oracle help
Goto Forum:
  


Current Time: Thu Dec 08 14:38:43 CST 2016

Total time taken to generate the page: 0.08161 seconds