display single record if records duplicates in a table in SQL code example

Example: sql count duplicate rows

SELECT _column, COUNT(*) 
FROM _table
GROUP BY _column
HAVING COUNT(*) > 1