Retreiving dups using SQL

[rboscia]

I am a newbie that needs help.
I have a table that contains customer telephone numbers (the telephone number is in 2 separate fields)and also a customer ticket #. I want to retrieve all the duplicates (and only the duplicates) of those telephone numbers by ticket #.
My output should look like this

Telephone # Ticket #
xxx-xxx-xxxx 1
8
Total # of Occurances ##

Telephone # Ticket #
xxx-xxx-xxxx 3
7
15
Total # of Occurances ##

I've tried various select queries, but not getting only the dups. Any help would be appreciated.
Thanks
Robin

 

[rboscia]

I no longer need this information. No need to reply to this post.
Thanks