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: Maximum Sum of Distinct Subarrays With Length K
Problem Statement
Problem of The Day: Defuse the Bomb
Problem Statement
Problem of The Day: Find the Power of K-Size Subarrays I
Problem Statement
Problem of The Day: Prime Subtraction Operation
Problem Statement