Hi All,

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