Title 5:mysql----------consecutive Numbers

Write a SQL query to find all numbers this appear at least three times consecutively.

+----+-----+| Id | Num |+----+-----+| 1  |  1  | | 2  |  1  | | 3  |  1  | | 4  |  2  | | 5  |  1  | | 6  |  2  | | 7  |  2  |+----+-----+

For example, given the above Logs table, was the only number that 1 appears consecutively for at least three times.

Topic Answer

# Write your MySQL query statement belowselect distinct num from (    select        num,        case            @prevNum = num th En @count: = @count + 1 when            (@prevNum: = Num) are not null and then @count: = 1        end n from    Logs, (select @prevNum : = NULL) r    Order by Id) a where n >= 3

Title 5:mysql----------consecutive Numbers