select distinct t1.Num as ConsecutiveNums
from
Logs t1
left join
Logs t2
on t1.Id = t2.Id - 1 and t1.Num = t2.Num
left join
Logs t3
on t2.Id = t3.Id -1 and t1.Num = t3.Num and t2.Num = t3.Num
where t2.Id is not null and t3.Id is not null
select distinct t1.Num as ConsecutiveNums
from
Logs t1
left join
Logs t2
on t1.Id = t2.Id - 1 and t1.Num = t2.Num
left join
Logs t3
on t2.Id = t3.Id -1 and t1.Num = t3.Num and t2.Num = t3.Num
where t2.Id is not null and t3.Id is not null