Hi to all,

This is may a out of topic but, I'm sure that somebody can help me.

I have the following table

Client (
AccNew Varchar(255),
AccOld Varchar(255),
Inst LONGTEXT,
name Varchar(255));

(*LONGTEXT, I use this data type in BDE with delphi)

This table don't have index neither primary key, of course I have a
duplicity in the data of this table.

That I need, is a way to remove the duplicated data considering the field
AccNew my primary key(I want one record by AccNew)

How can I do that?


Example:

Recno AccNew AccOld Inst Name
001 0000000001 1000000001 TEST1 MY NAME 1
002 0000000002 1000000012 TEST2 MY NAME 2
003 0000000001 1000000001 TEST1 MY NAME 1
004 0000000003 1100000013 TEST3 MY NAME 3
005 0000000004 1300000114 TEST4 MY NAME 4
006 0000000003 1100000013 TEST3 MY NAME 3

that I want is a way or an idea (SQL or something like that) to remove the
duplicated data

Recno AccNew AccOld Inst Name
001 0000000001 1000000001 TEST1 MY NAME 1
002 0000000002 1000000012 TEST2 MY NAME 2
003 0000000003 1100000013 TEST3 MY NAME 3
004 0000000004 1300000114 TEST4 MY NAME 4


Tnaks in advance.


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com