0 - 3 of 3 tags for duplicate

I have a requirement to update the duplicate records in teradata. For E.G. if col, col, col, col have same values in the table, those records are regarded as duplicates and duplicate flag needs to be updated as '1' for all those records.

Any suggestions on how implement this logic?

I've seen how to select distinct information, but I haven't successfully found anything for the opposite.  I'm looking to limit my search only to items with duplicate UPCs.  My query essentially looks like this...

Hi all,