Removing duplicate records from teradata table

Database
Enthusiast

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,

Tags (1)
1 REPLY
Enthusiast

Re: Removing duplicate records from teradata table

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,