I have a table with the following description:
user varchar(64)
outtime datetime
intime datetime
<other irrelevant columns>
I want to query this table from datetime1 to datetime2 at consistent
intervals. Unfortunately, the data is not in consistent intervals.
For example, I want to count the number of users in 5 minute intervals from
one datetime to the next. How would I do this without having to make a
query every 5 minute interval?
Many thanks in advance.
Brady...
bo****@hotmail.com