Create table Logs
(
Id int  primary key identity(1,1) not null,
Num int not null,
)
insert into Logs(Num) select 1
union all select 1
union all select 1
union all select 2
union all select 1
union all select 2
union all select 2


select distinct l1.Num as ConsecutiveNums   from  Logs l1, Logs l2, Logs l3   
 where l1.Id=l2.Id+1 and l2.Id=l3.Id+1  and l1.Num = l2.Num and l2.Num = l3.Num