All Forums Database
RAMKUMAR.9298 6 posts Joined 01/14
12 Feb 2014
Removing duplicate records from teradata table

Hello Folks,
We have to remove duplicates from our teradata table. If 3 similar records are there then 2 duplicates should be deleted and 1 actual record should be present in the table.
Could any one help me on this. 
Thanks,

Ramkumar
Tags:
Raja_KT 1246 posts Joined 07/09
12 Feb 2014

Hi Ramkumar,
There are umpteen suggestions available here :). ---[group by  and having or olap qualify way]
http://forums.teradata.com/forum/database/delete-duplicate-rows-from-table-in-teradata-database
http://forums.teradata.com/forum/training/how-to-delete-duplicate-records
http://forums.teradata.com/forum/database/deleting-duplicate-rows-in-multiset-table
I usually follow the temp table way as it is easier and safer :)
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.