Find duplicate records query

Use the following SQL statement for finding duplicates in a table. I think this should work
for any relational database, not only MySQL.

SELECT col_name, COUNT(col_name) AS num
FROM table_name
GROUP BY col_name
HAVING (COUNT(col_name) > 1);