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.
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 :)