Finding & Removing Duplicates [message #174490] |
Mon, 29 May 2006 07:03 |
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 |
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
|
|
|
|