Home » RDBMS Server » Server Administration » Finding & Removing Duplicates
Finding & Removing Duplicates [message #174490] Mon, 29 May 2006 07:03 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Consider a table like,

col1 col2 col3 col4
----- ----- ----- -----
1 2 3 4
1 2 3 4
1 2 3 5
2 3 4 5
2 3 4 5

Is there any method to find duplicates in this table & remove it,so that table should contain,

col1 col2 col3 col4
----- ----- ----- -----
1 2 3 4
1 2 3 5
2 3 4 5
Re: Finding & Removing Duplicates [message #174495 is a reply to message #174490] Mon, 29 May 2006 07:15 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Try searching for 'remove duplicates', 'delete duplicates', 'duplicates' I'm sure you can think of some other search possibilities.
This question is asked quite a lot on these forums.

Jim
Re: Finding & Removing Duplicates [message #174500 is a reply to message #174495] Mon, 29 May 2006 07:22 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
This is asked so frequently that we even have an FAQ entry for it at http://orafaq.com/faq/how_does_one_eliminate_duplicates_rows_from_a_table
Previous Topic: Solution required soon
Next Topic: Installing OLAP services & changing option values
Goto Forum:
  


Current Time: Fri Sep 20 12:51:48 CDT 2024