To find duplicate record in table

To find duplicate record in table
Query :

SELECT mff_id,
 COUNT(mff_id) AS NumOccurrences
FROM SmartMap
GROUP BY mff_id
HAVING ( COUNT(mff_id) > 1 )


Thanks