SQL problem - Consecutive Numbers
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
You may also enjoy
Problem of The Day: Numbers With Same Consecutive Differences
Problem Statement
Problem of The Day: Combination Sum III
Problem Statement
Problem of The Day: Largest Perimeter Triangle
Problem Statement
Problem of The Day: Triangle
Problem Statement