delete 2 of the 3 triplicates from a table
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Fri, 07 Feb 2014 11:31:03 -0500
Message-ID: <20140207163103.159710_at_gmx.com>
Hi,
I need to delete 2 of the 3 triplicates i found in a table. Anyone have an easy way to do that? Oracle 10.2.0.2 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
Date: Fri, 07 Feb 2014 11:31:03 -0500
Message-ID: <20140207163103.159710_at_gmx.com>
Hi,
I need to delete 2 of the 3 triplicates i found in a table. Anyone have an easy way to do that? Oracle 10.2.0.2 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 07 2014 - 17:31:03 CET