How to delete duplicated records ?

From: Danil Krasnov <danil_at_maginfo.net>
Date: 1998/11/23
Message-ID: <01be16f1$5106c480$168480c3_at_www>#1/1


Hello, Gurus !

[Quoted] [Quoted] [Quoted] There are duplicated records have been appeared in the table... reason is not clear, but its not a topic..
I have to delete duplicated records...

Example:

Table A:

Id Value1 Value2

[Quoted]  1    111       222
 2    111       222 
 3    111       222
 4    333       444
 5    333       444

[Quoted] The task - is to delete rows with id's 2, 3, 5...

Any suggestions?

Thanks in advance..



Danil Kranov
danil_at_maginfo.net Received on Mon Nov 23 1998 - 00:00:00 CET

Original text of this message