An easy way to find duplicate entries in a table

The above will list the phone numbers that are at least twice in the table and also show the number of occurrences

But often we need to show all the records containing the duplicate entries

we can do that with the following query

the query above will list all records with phone numbers that exist at least twice in the table ordered by phone number