I was trying to get my head around something and cant, I want to make a report for a client that is something like this:
sql queries the log table for all records from selected date
sql groups then into 5 min intervals
count the number in each group
plot onto graph
my question is can sql extract based on time interval? if not how would i do this?
thanx in advance