Write a query to find the duplicate rows from a table?

Select name, count(*) from tablename group by name having count(*)>1