By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Test(AA varchar(20),BB varchar(20),CC varchar(20),DD integer,EE integer);
insert into Test values ('201902','X','1000',1,1);
insert into Test values ('201902','X','1000',2,2);
insert into Test values ('201902','X','1001',4,3);
insert into Test values ('201902','Y','2000',6,4);
insert into Test values ('201902','Y','2001',8,5);
insert into Test values ('201903','Y','2002',10,6);
insert into Test values ('201904','Y','2002',12,7);
select *
from Test
where 1=1
order by AA,BB;
| AA | BB | CC | DD | EE |
|---|---|---|---|---|
| 201902 | X | 1000 | 1 | 1 |
| 201902 | X | 1000 | 2 | 2 |
| 201902 | X | 1001 | 4 | 3 |
| 201902 | Y | 2000 | 6 | 4 |
| 201902 | Y | 2001 | 8 | 5 |
| 201903 | Y | 2002 | 10 | 6 |
| 201904 | Y | 2002 | 12 | 7 |
select X.AA,X.BB,SUM(DD) AS DD
from (
select AA,BB,CC,max(EE) as EE
from Test
where 1=1
group by AA,BB,CC) as X
left join (
select AA,BB,CC,DD,EE from Test) as Y on X.AA=Y.AA and X.BB=Y.BB
and X.CC=Y.CC
and X.EE=Y.EE
where 1=1
group by X.AA,X.BB
order by X.AA,X.BB;
| AA | BB | DD |
|---|---|---|
| 201902 | X | 6 |
| 201902 | Y | 14 |
| 201903 | Y | 10 |
| 201904 | Y | 12 |