Get duplicate rows of a table


Get duplicate rows of a table
  
SELECT COUNT(*), colname FROM TABLE GROUP BY colname HAVING COUNT(*) > 1