Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Delete duplicate rows in Teradata

Step 1:
CREATE SET VOLATILE TABLE YOUR_VOLATILE_TABLE AS
(
SEL *
FROM YOUR_MAIN_TABLE

) WITH DATA ON COMMIT PRESERVE ROWS
;

Step 2:
DELETE FROM YOUR_MAIN_TABLE;

Step 3:
INSERT INTO YOUR_MAIN_TABLE SELECT * FROM YOUR_VOLATILE_TABLE;;



Since you are inserting into SET table, it will insert only the unique records.