doylelives
Para realizar una suma, se requiere tener establecido el parametro de agrupamiento que debe respetar si existen mas campos.
si lo que necesitas es algo así:
Código sql:
Ver original+----------+---------------------+------+-----------+------------+-----------------------------------------+
| 9 | 2009-05-19 18:47:43 | 5 | 8 | 2009 | 12 |
| 1 | 2009-07-14 00:00:00 | 7 | 8 | 2009 | 12 |
| 2 | 2008-09-15 00:00:00 | 9 | 8 | 2008 | 12 |
+----------+---------------------+------+-----------+------------+-----------------------------------------+
te recomendaría hacer una vista de la consulta y posteriormente, llamar la suma de la vista creada.
Código sql:
Ver originalmysql> CREATE VIEW orders_view AS SELECT COUNT(order_id)AS cantidad, order_date, MONTH(order_date)AS mes,
-> MONTH(date_sub( CURDATE() , INTERVAL 11 MONTH )) AS mesInicio,
-> YEAR(order_date)AS anioInicio
-> FROM orders
-> WHERE order_date>=date_sub(CURDATE(),INTERVAL 12 MONTH)
-> GROUP BY MONTH(order_date)
-> ;
Query OK, 0 ROWS affected (0.02 sec)
mysql> SELECT *,(SELECT SUM(cantidad) FROM orders_view) tope FROM orders_view;
+----------+---------------------+------+-----------+------------+------+
| cantidad | order_date | mes | mesInicio | anioInicio | tope |
+----------+---------------------+------+-----------+------------+------+
| 9 | 2009-05-19 18:47:43 | 5 | 8 | 2009 | 12 |
| 1 | 2009-07-14 00:00:00 | 7 | 8 | 2009 | 12 |
| 2 | 2008-09-15 00:00:00 | 9 | 8 | 2008 | 12 |
+----------+---------------------+------+-----------+------------+------+
3 ROWS IN SET (0.00 sec)
un saludo.