Home -> Usenet -> comp.databases.oracle -> Deleting duplicate rows from a table:SQL Command???

Deleting duplicate rows from a table:SQL Command???

From: <AH3141_at_uacsc2.albany.edu>
Date: Sun, 26 Sep 93 21:34:56 EDT
Message-ID: <16C5512F80S85.AH3141_at_uacsc2.albany.edu> 






Is there an SQL command that will delete duplicate rows from a table based on
the following criteria?
 


Table1 has two columns: id char(5),    id_date date.
 


   delete from table1 where id=id and id_date < id_date
 


I would like to be left with a unique id with the most current date.
 
 


Thanks,


Alicia
Received on Mon Sep 27 1993 - 02:34:56 CET












Original text of this message