1 |
1 |
1 |
2 |
1 |
2 |
2 |
SELECT distinct A.Num as ConsecutiveNums
FROM
Logs A,
Logs B,
Logs C
WHERE
A.Id = B.Id - 1
AND B.Id = C.Id - 1
AND A.Num = B.Num
AND B.Num = C.Num
1 |
1 |
1 |
2 |
1 |
2 |
2 |
SELECT distinct A.Num as ConsecutiveNums
FROM
Logs A,
Logs B,
Logs C
WHERE
A.Id = B.Id - 1
AND B.Id = C.Id - 1
AND A.Num = B.Num
AND B.Num = C.Num