Duplicate Phone number

Question

Because of poor data entry policies, there are a lot of duplicate phone numbers to the same customers. I need to write a query that will list all customers with the same phone number.

Thanks for your help.

What does your query look like so far? Stack Overflow isn't a "write me a query" site, you need to show some effort. — LittleBobbyTables - Au Revoir, Mar 06 '13 at 21:02
Depending on your data format you may want to strip non-numeric characters (if any) before comparing numbers. — PM 77-1, Mar 06 '13 at 21:07
And what is your table design? Do you have a PK on the table? — HLGEM, Mar 06 '13 at 21:13

score 4 · Accepted Answer · answered Mar 06 '13 at 21:21

4

;WITH dupes AS
(
  SELECT Phone_Number
  FROM dbo.Customer_Table
  GROUP BY Phone_Number
  HAVING COUNT(*) > 1
)
SELECT c.Customer_Name, dupes.Phone_Number
  FROM dupes 
  INNER JOIN dbo.Customer_Table AS c
  ON dupes.Phone_Number = c.Phone_Number;

answered Mar 06 '13 at 21:21

Aaron Bertrand

272,866
37
466
490

Duplicate Phone number

1 Answers1