Duplicate Table

Question

Hi,


I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.




Thanks