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
2023-02-12
10.00
10.00

2
2023-02-22
20.00
30.00

3
2023-03-04
30.00
60.00

4
2023-03-14
40.00
100.00

5
2023-03-24
50.00
150.00

ID_TRADE	EXIT_DATE	ERGEBNIS	SUMME
1	2023-02-12	10.00	10.00
2	2023-02-22	20.00	30.00
3	2023-03-04	30.00	60.00
4	2023-03-14	40.00	100.00
5	2023-03-24	50.00	150.00