Hi everyone,
i have two columns (seconds, number of calls), i need to produce a
report which will show total number of calls in intervals (let'say 10
seconds interval), i know i can do this programmability in my script but
i was wondering if it's possible to accomplish this behavior within
mysql. for example i have following data.
+----------+---------------+
| calls | queue_seconds |
+----------+---------------+
| 250 | 0.00 |
| 28 | 1.00 |
| 30 | 2.00 |
| 56 | 3.00 |
| 23 | 4.00 |
| 31 | 5.00 |
| 33 | 6.00 |
| 50 | 7.00 |
| 49 | 8.00 |
| 62 | 9.00 |
| 74 | 10.00 |
...
... and so on...
...
+----------+---------------+
now result should look like this with a 5 seconds interval.
+----------+---------------+
| count(*) | queue_seconds |
+----------+---------------+
| 250 | 0.00 |
| 168 | 5.00 |
| 268 | 10.00 |
...
... and so on...
...
+----------+---------------+
i would really appreciate your help.
Best Regards.
--
Ghulam Mustafa
