Question

Write a query to find the all duplicate name from table

Answer 1

Explanation:

SQL Query to find the duplicate records in the table in MySQL.

1. mysql> select * from contacts ;

2. mysql> select name , count ( name ) from contacts group by name ;

3. mysql> select name , count ( name ) from contacts group by name ; phone ;