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);