Re: How to delete duplicated records ?

Try

DELETE table_a x
WHERE exists (SELECT 'x'

               FROM   table_a y
               WHERE  x.value1 = y.value1
               AND    x.value2 = y.value2
               AND    x.rowid <> y.rowid
              )

Danil Krasnov (danil_at_maginfo.net) wrote:

: Hello, Gurus !
 

: 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
 

: 1 111 222
: 2 111 222
: 3 111 222
: 4 333 444
: 5 333 444
 

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

: Any suggestions?
 

: Thanks in advance..
 

: ------------
: Danil Kranov
: danil_at_maginfo.net

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.