Delete Duplicatea query

[croby]

Hi,

I have a file, which contains many Duplicates in one field.

There are 2 situations:

(1) full data duplicates in one field. Example :

Name Volumn
---------------------------
classicbook 2
claasicbook 3
classicbook 1
poembook 1
poembook 4

I want to delete the 2nd, 3rd and 5th row. The new table should look:

classicbook 2
poembook 4

(2) Partial data duplicates in one field. Example:

FILE NAME REMARK
-------------- -----------------
TTYK.ANNNU.BACKUP ??????
TTYK.ANNNU.BACKUP.G0750V00 MIGRAT
TTYK.ANNNU.BACKUP.G0751V00 MIGRAT
TTYK.ANNNU.BACKUP.G0752V00 MIGRAT
TTYK.ANNNU.BACKUP.G0753V00 MIGRAT
TTYK.ANNNU.BACKUP.G0754V00 MIGRAT
TTYK.ANNNU.BACKUP ??????
ZZYK.ANNNU.BACKUP.G0750V00 MIGRAT
ZZYK.ANNNU.BACKUP.G0751V00 MIGRAT
ZZYK.ANNNU.BACKUP.G0752V00 MIGRAT
ZZYK.ANNNU.BACKUP.G0753V00 MIGRAT

I only need the first row and the last row for duplicated rows. The new table should look:

TTYK.ANNNU.BACKUP ??????
TTYK.ANNNU.BACKUP.G0754V00 MIGRAT
ZZYK.ANNNU.BACKUP ??????
ZZYK.ANNNU.BACKUP.G0754V00 MIGRAT

Currently, I have to do it manually. Very time consuming work. Any help will be greatly appreciated. Chris

 

[croby]

Delete Duplicates query

Hi, The data in the tables look jamed. For the first situation, there 2 fields: Name and Volumn. For the 2nd situation, there are 2 fields: Filename and Remark. Chris