Duplicate Rows and DELETE Processing - Advanced SQL Engine - Teradata Database

Duplicate rows in a MULTISET table cannot be distinguished. When a WHERE condition identifies duplicate rows, all duplicate rows are deleted.