SQL Query to Find the Duplicate records form Table

SELECT name, partner, COUNT(*) FROM display_info GROUP BY name, partner HAVING COUNT(*) > 1

In above query display_info  is the table name. this query gives to the duplicate data and number of times repeated that data