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. 

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]
I usually follow the temp table way as it is easier and safer :)

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.