Show All Duplicate Records QUERY

What is the query that will show all the records that have multiple names?

For example.

Table 1:

| ID | Name    | Age   | Email           |
+----+---------+-------+-----------------+
| 1  | Mike    | 12    | [e-mail]  |
| 2  | Mon     | 10    | [e-mail]   |
| 3  | Peter   | 12    | [e-mail]   |
| 4  | Mike    | 13    | [e-mail]|

Desired result:

| ID | Name    | Age   | Email           |
+----+---------+-------+-----------------+
| 1  | Mike    | 12    | [e-mail]  |
| 4  | Mike    | 13    | [e-mail]|

Answer

You can use GROUP BY and join result to origin table

SELECT t1.*
FROM myTable t1

JOIN

  (SELECT Name
   FROM myTable
   GROUP BY Name
   HAVING COUNT(Name) > 1) t2

ON t1.Name = t2.Name