To find duplicate rows in table

--To find duplicate rows in table

select colname, count(colname) from TableName
Group by colname Having (count(colname) > 1)