Re: How to delete duplicated records ?

> There are duplicated records have been appeared in the table.
> 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...
>
> Thanks in advance..
>
> ------------
> Danil Kranov
> danil_at_maginfo.net
>

delete from a
where exists (select null from a b
 where b.id>a.id and b.value1=a.value1 and b.value2=a.value2) Received on Mon Nov 23 1998 - 00:00:00 CET