[thelist] SQL- grouping and dates

rudy r937 at interlog.com
Tue Apr 3 13:45:11 CDT 2001


> Is it possible to do it in the same query?  It is easy enough
> to add a second query to pull these back, but if you have a
> large record set, these extra queries could add up.

hi chris

you're right, and yes, it is possible to do it in one query

you said that

   SELECT root, count(message), max(updated) 
    FROM ???
     GROUP BY root

is okay, but it returns only one row for each root

what did you want to see from the combined query?

rudy.ca





More information about the thelist mailing list