count occurrences with duplicate entries sql code example

Example: sql count duplicate rows

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