delete 2 of the 3 triplicates from a table

From: Lyall Barbour <>
Date: Fri, 07 Feb 2014 11:31:03 -0500
Message-ID: <>

 I need to delete 2 of the 3 triplicates i found in a table. Anyone have an easy way to do that? Oracle table has two columns, the ID that has triplicates in it and a date column (sysdate of when info went into table) I found the triplicates with
select <id column> from <table>
group by <id column>
having (count(<id column) > 1); -- then sub sequently, > 2 (> 3 returned no rows) Thanks
Lyall Barbour
Received on Fri Feb 07 2014 - 17:31:03 CET

Original text of this message