Home » SQL & PL/SQL » SQL & PL/SQL » How to delete duplicate rows?
How to delete duplicate rows? [message #309950] Sun, 30 March 2008 09:07 Go to next message
kishan_nag
Messages: 19
Registered: June 2005
Location: Mumbai
Junior Member

How to delete duplicate rows from below table?

Table Structure:

1) It having 200 columns
2) No constraints
3) Duplicate row should having same data for columns


Thanks in advance.

Regards,
RAM
Re: How to delete duplicate rows? [message #309951 is a reply to message #309950] Sun, 30 March 2008 09:10 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Try doing a search for the topic. This has been asked and answered many many times.
Previous Topic: After/Before Insert Trigger
Next Topic: Relation beween ORA-01555 and ORA-01427
Goto Forum:
  


Current Time: Sun Nov 03 07:24:15 CST 2024