Chris,
What I want to do is find all the groups where the inserts all
happened with in say 10 seconds. So my group by would be more like..
Perhaps the easiest solution is to make a temp table of datetime ranges
from the resultset, then join from and group by those rowIDs.
PB
-
Chr
Hi,
Chris W wrote:
I have the following query...
SELECT CreateDate, count( * )
FROM `userprofile`
GROUP BY CreateDate
It isn't exactly what I want. Records are added to this table in 2 main
ways. First people use the web site interface to create records. In
this case, records are only added
I have the following query...
SELECT CreateDate, count( * )
FROM `userprofile`
GROUP BY CreateDate
It isn't exactly what I want. Records are added to this table in 2 main
ways. First people use the web site interface to create records. In
this case, records are only added by one or 2 people a
