Removing Duplicates in TERADATA

Removing Duplicates

In case of Complete Row Duplicate

1. Take a new table with SET option
2. Load the duplicate data, so unique rows loaded
3. Drop old table and Rename new table name to old table name

In case of same column are duplicates

1. Take a new Table
2. Load the Distinct rows or Group by Queried rows into it, so unique rows loaded.
3. Drop old table and  Rename new table name to old table name

Note: If u want to eliminate complete row duplicates then Take SET Table