By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table data_start (
CALMONTH int,
COSTCENTER varchar(20),
Kontonummer varchar(20)
);
insert into data_start values
(202301, 'A', 'AA'),
(202302, 'A', 'AB'),
(202101, 'B', 'BA'),
(202012, 'B', 'BB'),
(202204, 'C', 'CA'),
(202312, 'C', 'CB');
Records: 6 Duplicates: 0 Warnings: 0
select t.*
from data_start t
inner join (
select COSTCENTER
from data_start
group by COSTCENTER
having max(CALMONTH) > 202201
) as s on s.COSTCENTER = t.COSTCENTER;
| CALMONTH | COSTCENTER | Kontonummer |
|---|---|---|
| 202301 | A | AA |
| 202302 | A | AB |
| 202204 | C | CA |
| 202312 | C | CB |