Firebird 3.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(12,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-01-17
10.00
10.00

2
2024-01-27
20.00
30.00

3
2024-02-06
30.00
60.00

4
2024-02-16
40.00
100.00

5
2024-02-26
50.00
150.00

ID_TRADE	EXIT_DATE	ERGEBNIS	SUMME
1	2024-01-17	10.00	10.00
2	2024-01-27	20.00	30.00
3	2024-02-06	30.00	60.00
4	2024-02-16	40.00	100.00
5	2024-02-26	50.00	150.00