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 Integer)
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
2023-02-02
10
10

2
2023-02-12
20
30

3
2023-02-22
30
60

4
2023-03-04
40
100

5
2023-03-14
50
150

ID_TRADE	EXIT_DATE	ERGEBNIS	SUMME
1	2023-02-02	10	10
2	2023-02-12	20	30
3	2023-02-22	30	60
4	2023-03-04	40	100
5	2023-03-14	50	150