To find duplicates in a table in Teradata

GROUP BY clause can be used to find the duplicates in a table by associating the columns.
Suppose, a table is containing 3 columns named col1, col2, col3 then

SELECT col1, col2, col3, COUNT(*)
FROM
database.table
GROUP BY col1, col2, col3
HAVING COUNT(*) >1


If you want to find duplicates over whole table, all the columns must be supplied in GROUP BY clause.