Postgres 9.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table orders (
  orderdate date not null
);

CREATE TABLE


insert into orders values
  ('20220701'),
  ('20221231'),
  ('20230101'),
  ('20230701'),
  ('20240101');

INSERT 0 5


select
  *
from orders
where
  orderdate in (
    select max(orderdate)
    from orders
    where orderdate >= '20220101'
      and orderdate < '20230101'
    union all
    select orderdate
    from orders
    where orderdate >= '20230101'
      and orderdate < '20240101'
  );


orderdate


2022-12-31

2023-01-01

2023-07-01



SELECT 3


select *
from (
  select
    *,
    lead(orderdate, 1) over(order by orderdate) lead_odate
  from orders
  where orderdate >= '20220101'
    and orderdate < '20240101'
) t
where lead_odate is null or
  (lead_odate >= '20230101'
   and lead_odate < '20240101');


orderdate
lead_odate


2022-12-31
2023-01-01

2023-01-01
2023-07-01

2023-07-01
null



SELECT 3


truncate table orders;

TRUNCATE TABLE


insert into orders values
  ('20210701'),
  ('20211231'),
  ('20230101'),
  ('20230701'),
  ('20240101');

INSERT 0 5


select
  *
from orders
where
  orderdate in (
    select max(orderdate)
    from orders
    where orderdate >= '20220101'
      and orderdate < '20230101'
    union all
    select orderdate
    from orders
    where orderdate >= '20230101'
      and orderdate < '20240101'
  );


orderdate


2023-01-01

2023-07-01



SELECT 2


select *
from (
  select
    *,
    lead(orderdate, 1) over(order by orderdate) lead_odate
  from orders
  where orderdate >= '20220101'
    and orderdate < '20240101'
) t
where lead_odate is null or
  (lead_odate >= '20230101'
   and lead_odate < '20240101');


orderdate
lead_odate


2023-01-01
2023-07-01

2023-07-01
null



SELECT 2