Help with query 1

[extremedatos]

Hi all,

I need help with a query im not an sql guy. this is what i need.

select * from tblparticipant09
Here i have a column call "nvcPhoneNumber" I need to how many duplicated "phonenumbers" i have?

Thanks.

 

[r937]

SELECT nvcPhoneNumber
  FROM tblparticipant09
GROUP
    BY nvcPhoneNumber
HAVING COUNT(*) > 1

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[extremedatos]

r937,

i only got one column how do i know how many times each phonenumber was repeated?

thanks

 

[r937]

SELECT nvcPhoneNumber
     , [blue]COUNT(*) AS how_many_times[/blue]
  FROM tblparticipant09
GROUP
    BY nvcPhoneNumber
HAVING COUNT(*) > 1

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[extremedatos]

thanks man!!!