SQL problem - Consecutive Numbers

1 min read 104 words

Problem

Query

SELECT DISTINCT
    l1.num AS ConsecutiveNums
FROM
    Logs AS l1,
    Logs AS l2,
    Logs AS l3
WHERE 
    l1.num = l2.num AND l1.num = l3.num AND l1.id = l2.id - 1 AND l1.id = l3.id - 2