Count the duplicate row from values in mysql

 select id,name, phoneNumber, count(phoneNumber) as "Total" from contacts group by phoneNumber HAVING COUNT(phoneNumber);