Db2 11.1

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

create table t (id int, start date, end date);
insert into t (id, start, end) values (1, '2021-01-13', '2021-04-15');
insert into t (id, start, end) values (1, '2021-04-16', '2021-11-28');
insert into t (id, start, end) values (1, '2021-11-29', null);
insert into t (id, start, end) values (2, '2021-05-05', '2021-09-13');
insert into t (id, start, end) values (2, '2021-09-13', '2021-12-31');
insert into t (id, start, end) values (3, '2020-01-09', '2021-08-29');
insert into t (id, start, end) values (3, '2021-08-30', '2023-04-15');
select *
from t
where end <= date '2021-12-31'
order by end desc
fetch next 1 rows only


ID
START
END


2
2021-09-13
2021-12-31