sql count non duplicates code example

Example: sql count duplicate rows

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