Firebird 4.0

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

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

SELECT zuKonto,id_trade, EXIT_DATE, Ergebnis, SUM(Ergebnis) OVER(PARTITION BY zuKonto ORDER BY EXIT_DATE, id_trade) AS SumTotal
FROM tbtrades
WHERE (Entry_Date >='27.12.2022' AND Exit_Date <= '31.03.2023') /*AND
          zuKonto = '4'*/
ORDER BY zuKonto,EXIT_DATE, id_trade



ZUKONTO
ID_TRADE
EXIT_DATE
ERGEBNIS
SUMTOTAL


3
1
2023-02-11
10.00
10.00

3
3
2023-03-03
30.00
40.00

3
5
2023-03-23
50.00
90.00

4
2
2023-02-21
20.00
20.00

4
4
2023-03-13
40.00
60.00

ZUKONTO	ID_TRADE	EXIT_DATE	ERGEBNIS	SUMTOTAL
3	1	2023-02-11	10.00	10.00
3	3	2023-03-03	30.00	40.00
3	5	2023-03-23	50.00	90.00
4	2	2023-02-21	20.00	20.00
4	4	2023-03-13	40.00	60.00