Archives of the TeradataForum

Message Posted: Mon, 14 Jul 2014 @ 23:17:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This was posted to the TDAT-L forum some time ago......

0) Backup the table.

1) Create clone of your table (without data)

2) INSERT INTO SELECT * FROM QUALIFY ROW_NUMBER() OVER(PARTITION BY ORDER BY ) = 1;

3) DELETE FROM ;

4) INSERT INTO SELECT * FROM ; OR RENAME TABLE AS _old; RENAME TABLE AS ;

5) DROP whichever table is remaining depending on which approach you took in step 4.

6) Backup the newly cleansed table.

	<Prev	Next>		<<First	<Prev	Next>	Last>>