Topic: Filling weeding values from the last lines. (The rising total)
I can not understand with simple in any way, at first sight the task.
As by means of SQL to implement request, in which additional field value of all fields of the last line will settle up.
For example: There is table , with fields date (date), number (number).
How to write request that the additional field calculated number of the present and all previous ?
Studied an example at a forum, but in the core all examples with the description of implementation of an output only the previous value.
SELECT ., ., ., (SELECT TOP 1 2. FROM incomes AS 2 WHERE 2. <. ORDER BY 2. DESC) AS _ FROM incomes ORDER BY .