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
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.

Re: How to delete duplicate rows? [message #309951 is a reply to message #309950] Sun, 30 March 2008 09:10 Go to previous message
Messages: 2818
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: Wed Oct 26 11:06:22 CDT 2016

Total time taken to generate the page: 0.12956 seconds