[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