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: Kth Largest Element in an Array
Problem Statement
Problem of The Day: Nearest Exit from Entrance in Maze
Problem Statement
Problem of The Day: Rotting Oranges
Problem Statement
Problem of The Day: Evaluate Division
Problem Statement