id int,

Timestamps datetime

);

insert into mytable values

(1 , '2022-09-23 15:01:00'),

(2 , '2022-09-23 15:02:00'),

(3 , '2022-10-03 14:52:00'),

(4 , '2022-10-03 14:53:00'),

(5 , '2022-10-03 14:54:00'),

(6 , '2022-10-03 14:56:00'),

(7 , '2022-10-03 14:57:00'),

(8 , '2022-10-03 14:58:00'),

(9 , '2022-10-03 14:59:00');

select *, lead(Timestamps) over (order by Timestamps) as lead,

case when

datediff(mi, Timestamps, LEAD(Timestamps) over (order by Timestamps)) = 1 then 0 else 1 end as diff

from mytable

)

select *

from cte

select *, lead(Timestamps) over (order by Timestamps) as lead,

case when

datediff(mi, Timestamps, LEAD(Timestamps) over (order by Timestamps)) = 1 then 0 else 1 end as diff

from mytable

),

cte2 as (

select *, sum(diff) over(order by Timestamps) as grp

from cte

)

select grp+1 as range_id, min(Timestamps) as [From], max(lead) as [To]

from cte2

where lead is not null

group by grp