agrupar por hora

[leonardo_josue]

Hola medcol:

Checa este script a ver si es lo que necesitas:

Código MySQL:

mysql> SELECT * FROM tabla;
+----------+------+
| horas    | cant |
+----------+------+
| 08:02:00 |    2 |
| 08:20:13 |   18 |
| 09:02:14 |  500 |
| 09:45:13 |  120 |
+----------+------+
4 rows in set (0.02 sec)
 
mysql> SELECT HOUR(horas), SUM(cant)
    -> FROM tabla
    -> GROUP BY HOUR(horas);
+-------------+-----------+
| HOUR(horas) | SUM(cant) |
+-------------+-----------+
|           8 |        20 |
|           9 |       620 |
+-------------+-----------+
2 rows in set (0.00 sec)
 

Saludos
Leo.