Chris,
>I would like to query all rows that have more
>than one person with the same email address.
select id,count(emailaddr) as howmany
from tbl t1 join tbl t2 using(emailaddr)
group by id
having howmany>1;
PB
-----
Chris W wrote:
I have a
table of people with one of the fields being the email address. I
would like to query all rows that have more than one person with the
same email address. For example if the data were like this...
A 123@abc.com
B 456@xyz.com
C 984@jki.com
D 123@abc.com
E 456@xyz.com
F 321@ghi.com
The query would return row A, D, B, and E, in that order. It would
not return C or F