Removing duplicates

UDA

Removing duplicates

Can you people help in suggesting a query which can help me in deleting duplicate records from the table without using temporary work table??
4 REPLIES
Enthusiast

Re: Removing duplicates

No.
Teradata does not have a similar concept to Oracles' Rowid. You will have to do an Insert/ Select Distinct.
Junior Supporter

Re: Removing duplicates



If you have a big table with few duplicated rows and you don't want to do a massive INSERT...SELECT DISTINCT into a brand new table, you could do something like this - though this could be called 'cheating', I think ;-) -

http://carlosal.wordpress.com/2009/12/07/borrando-filas-duplicadas-en-teradata/

Cheers.

Carlos.

Re: Removing duplicates

Thanks Carlos for ur answer!!!It may not be the right approach,it helped me a lot....we shall wait for more thoughts!!
Enthusiast

Re: Removing duplicates

do the fastexport of source table  and do the fastload to your target table.

or 

insert into tablename

select * from tablename

union

select * from tablename