create table test.tmp1(p1 integer, p2 integer, p3 varchar( 20 ), p4 date, psut integer, ptonn integer);

insert into test.tmp1 values( 1 , 1 ,'aaa','1.1.2007', 20 , 100 );
insert into test.tmp1 values( 1 , 2 ,'aaa','1.1.2007', 13 , 75 );
insert into test.tmp1 values( 3 , 4 ,'aaa','12.1.2007', 17 , 86 );
insert into test.tmp1 values( 5 , 6 ,'aaa','12.1.2007', 21 , 99 );
insert into test.tmp1 values( 7 , 8 ,'aaa','1.2.2007', 5 , 23 );
insert into test.tmp1 values( 5 , 6 ,'aaa','15.3.2007', 13 , 13 );
insert into test.tmp1 values( 5 , 5 ,'aaa','2007-05-20', 5 , 10 );
insert into test.tmp1 values( 5 , 5 ,'aaa','2007-05-21', 5 , 10 );

select
p1,
p2,
p3,
p4,
PsutTonn,
PsutVag,
(select sum(Psut) from test.tmp1 AS d1 where d1.p4<=d0.p4 ) AS NachMes From test.tmp1 AS d0 where p4>='01.01.2007' and p4<='01.12.2007' order by p4;

select t.P3, 
year(t.P4), month(t.P4), sum(t.PSUT) from TEST.TMP1 t
group by t.P3, year(t.P4), month(t.P4)

select p4, psut
, sum(psut) over(partition by year(p4), month(p4) order by p4) psut_agg
from test.tmp1 t
order by p4;