Hi,
Is it possible for me to do a SELECT COUNT(*) and GROUP BY the answers based
on a INTERVAL e.g. HOUR?
the e.g. data:
+------------+
| id | time |
+------------+
| 1 | 08:30 |
| 2 | 09:30 |
| 3 | 09:31 |
| 4 | 09:32 |
+------------+
The answer I want from the e.g. data above if using INTERVAL HOUR
+----------+
| COUNT(*) |
+----------+
| 1 |
| 3 |
+----------+
It it's possible, how do i write it? or if it's not possible, what can I do
instead?
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
Office: +46 457 44184
Cellular: +46 709 798897
PS. database, sql, query, table <- I want this mail to be accepted =)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php