SQL Server 2022

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

CREATE TABLE ranges (
    StartDate DATETIME2(7), 
    EndDate DATETIME2(7),
    CreatedDate DATETIME2(7),
    Cost DECIMAL
);

INSERT INTO ranges(StartDate, EndDate, CreatedDate, Cost)
VALUES
('2024-01-02 00:00:00', '2024-01-05 00:00:00', '2023-07-10 19:40:19.60', 10.00),
('2024-01-02 00:00:00', '2024-01-03 00:00:00', '2023-07-10 19:41:45.73', 5.00),
('2024-01-02 00:00:00', '2024-01-05 00:00:00', '2023-07-10 19:45:32.76', 22.00),
('2024-01-03 00:00:00', '2024-01-05 00:00:00', '2023-07-10 19:54:41.60', 44.00),
('2024-01-04 00:00:00', '2024-01-04 00:00:00', '2023-07-10 19:54:52.60', 50.00);
5 rows affected

DELETE r1
FROM ranges r1
WHERE EXISTS (SELECT 1
    FROM (
        SELECT *,
          PrevEndDate = LAG(EndDate) OVER (ORDER BY StartDate)
        FROM ranges r2
        WHERE r2.CreatedDate > r1.CreatedDate
          AND r1.StartDate < r2.EndDate
          AND r1.EndDate > r2.StartDate
    ) r2
    HAVING COUNT(CASE WHEN PrevEndDate < StartDate THEN 1 END) = 0
       AND MIN(r2.StartDate) <= r1.StartDate
       AND MAX(r2.EndDate)   >= r1.EndDate
);
Warning: Null value is eliminated by an aggregate or other SET operation.
2 rows affected

SELECT * FROM ranges


StartDate
EndDate
CreatedDate
Cost


2024-01-02 00:00:00.0000000
2024-01-05 00:00:00.0000000
2023-07-10 19:45:32.7600000
22

2024-01-03 00:00:00.0000000
2024-01-05 00:00:00.0000000
2023-07-10 19:54:41.6000000
44

2024-01-04 00:00:00.0000000
2024-01-04 00:00:00.0000000
2023-07-10 19:54:52.6000000
50

StartDate	EndDate	CreatedDate	Cost
2024-01-02 00:00:00.0000000	2024-01-05 00:00:00.0000000	2023-07-10 19:45:32.7600000	22
2024-01-03 00:00:00.0000000	2024-01-05 00:00:00.0000000	2023-07-10 19:54:41.6000000	44
2024-01-04 00:00:00.0000000	2024-01-04 00:00:00.0000000	2023-07-10 19:54:52.6000000	50