Subconsultas

[leonardo_josue]

Hola Marrselo:

Tú mism@ nos diste la respuesta:

( hacer un SUM(monto) from pagos where id <"que el id actual")

Código MySQL:

mysql> select id, total, cuota,
    -> ifnull((select sum(total) from pagos T2
    -> where T2.id < T1.id), 0) calculado
    -> from pagos T1;
+-----+-------+-------+-----------+
| id  | total | cuota | calculado |
+-----+-------+-------+-----------+
|  21 | 50.00 |     1 |      0.00 |
|  22 | 50.00 |     2 |     50.00 |
|  23 | 50.00 |     3 |    100.00 |
|  45 | 20.00 |     4 |    150.00 |
|  67 | 10.00 |     4 |    170.00 |
|  88 |  5.50 |     4 |    180.00 |
|  91 | 14.50 |     4 |    185.50 |
| 102 | 50.00 |     5 |    200.00 |
| 110 | 50.00 |     6 |    250.00 |
+-----+-------+-------+-----------+
9 rows in set (0.45 sec)
 

Saludos
Leo.