SQL Server 2022

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

create table mytable(id int, ForecastDate date);

insert into mytable values
(1,'2023-12-05'),(2,'2024-01-03'),(3,'2024-04-01'),(4,'2024-04-01'),(5,'2024-04-01');
5 rows affected

select mytable.*
from mytable
order by id desc


id
ForecastDate


5
2024-04-01

4
2024-04-01

3
2024-04-01

2
2024-01-03

1
2023-12-05


WITH cte1 AS (
    SELECT min(id) id, ForecastDate
    FROM mytable
    GROUP BY ForecastDate
), cte2 AS (
    SELECT *
        , ROW_NUMBER() OVER (ORDER BY Id DESC) rn
    FROM cte1
)
SELECT id, ForecastDate
FROM cte2
WHERE rn = 2;


id
ForecastDate


2
2024-01-03