[thesite] rudy, this may intersest you..
Scott Dexter
sgd at ti3.com
Fri Oct 5 11:51:05 CDT 2001
> :
> : select who, lastlogin, createdate from users group by email having
> : count(*) > 1
> :
in SQL server, this would give an error that your group by doesn't
include anything in your select list.
something like:
select email, who, lastlogin, createdate from users group by email,
who, lastlogin, createdate having count(email) > 1
may be better
> : is giving me a "Not a group by" expression.. sorry about the dumb
> : questions, I'm only on page 75 of my "Learn to be Rudy in
> 21 days" book :)
>
(I'm only on page 137)
sgd
More information about the thesite
mailing list