» Unlabelled » How to find duplicates in a table? | Teradata Interview Questions

Thursday, 25 October 2012

How to find duplicates in a table? | Teradata Interview Questions

Group by those fields and select id, count(*) from table group by id having count (*) > 1
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)