[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