[thesite] rudy, this may intersest you..

[Joshua Olson]

: > select who,  lastlogin, createdate
: >      from users
: >     where exists
: >   (select 1 from users u2
: >       where u2.email = users.email
: >         and u2.userid != user.userid)
: >
: > Or something like that.
:
: indeed, that's pretty close -- in fact it does give you the
: right answer, except that it includes every user twice!

I don't think it does because of the u2.userid != user.userid conditional.
That makes sure it excludes counting itself.

Of course, putting the group by subquery in the IN clause is a much better
answer.  Can you say, deja vu?  I think we covered something like this on
thelist about a month ago.

And then you say,

: (he said, confidently, not having bothered to test it)

DOAH!


-joshua