|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
counting and selecting duplicates?
Hello: Is it possible to write a SQL query to display only Emails that are more then one of and how many? For example if I had the following emails in my table it would tell me that I have $number of $email but only if there is a double email address? foo@foo.com foo@foo.com test@test.com foo@foo.com 3|foo@foo.com I hope that makes sense |
|
#2
|
|||
|
|||
|
RE: counting and selecting duplicates?
SELECT count(*), email FROM `table` GROUP BY email HAVING count(*) > 1
|
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > counting and selecting duplicates? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|