如何确定SQL Server中具有重叠的连续日期记录

I know there are similar questions, but didn't find the answer for this specific case. Assume I have the following date ranges in the table (order by dates) :I know there are similar questions, but didn't