Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Query Problem
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
SQL Query Problem
Miscellaneous
Thread ID:
00640926
Message ID:
00640926
Views:
67
Im havnig problems getting this query to work right. What I have is a table of logins to a website. In the table containes the dattime of the loging along with other info. I need a query containing the number of logins within every 10 minute time interval.

For example

1/1/02 12:00 pm to 1/1/02 12:10 pm - 10 logins
1/1/02 12:10 pm to 1/1/02 12:20 pm - 15 logins
1/1/02 12:20 pm to 1/1/02 12:30 pm - 6 logins
...

I hope this makes sence. Any ideas?

Eric Stephani
Next
Reply
Map
View

Click here to load this message in the networking platform