Finding duplicates in a table using SQL

In Transact SQL duplicate rows for a table mytable based on column mycolumn may be found as follows:

SELECT myfield, COUNT(*)
FROM mytable
GROUP BY myfield
HAVING COUNT(*) > 1;