Firebird 4.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tbtrades(id_trade integer, EXIT_DATE date, Ergebnis NUMERIC(9,2))
EXECUTE BLOCK AS BEGIN
insert into tbtrades values(1, CURRENT_DATE-50, 10);
insert into tbtrades values(2, CURRENT_DATE-40, 20);
insert into tbtrades values(3, CURRENT_DATE-30, 30);
insert into tbtrades values(4, CURRENT_DATE-20, 40);
insert into tbtrades values(5, CURRENT_DATE-10, 50);
END
5 rows affected

SELECT id_trade, EXIT_DATE, ergebnis, SUM(ergebnis) OVER(ORDER BY exit_date) AS Summe
FROM tbtrades
ORDER BY EXIT_DATE


ID_TRADE
EXIT_DATE
ERGEBNIS
SUMME


1
2024-02-29
10.00
10.00

2
2024-03-10
20.00
30.00

3
2024-03-20
30.00
60.00

4
2024-03-30
40.00
100.00

5
2024-04-09
50.00
150.00

ID_TRADE	EXIT_DATE	ERGEBNIS	SUMME
1	2024-02-29	10.00	10.00
2	2024-03-10	20.00	30.00
3	2024-03-20	30.00	60.00
4	2024-03-30	40.00	100.00
5	2024-04-09	50.00	150.00