consecutive-numbers.sql (306B)
1 --Return all numbers that occur at least 3 times consecutively 2 --where they are ordered by their id. 3 4 SELECT Logs.num ConsecutiveNums 5 FROM Logs 6 WHERE Logs.num = (SELECT L.num FROM Logs as L 7 WHERE L.id = Logs.id + 1) 8 AND Logs.num = (SELECT L.num FROM Logs as L 9 WHERE L.id = Logs.id + 2) 10 GROUP BY Logs.num