How can we calculate the duplicate records in table ?

Question

I have a table containing the username and mobile no how can I found the duplicate records in that table based on these column names.

 

Can anyone help me with the exact query, not with the links

 

Thanks in Advance!