Leetcode 180 连续出现的数字

1
2
3
4
5
6
7
8
9

SELECT DISTINCT num AS ConsecutiveNums
FROM (
SELECT num, (CASE
            WHEN @prev = num THEN @cur := @cur +1
            WHEN @prev := num THEN @cur := 1
            END) AS ran
FROM Logs, (SELECT @prev := NULL, @cur := 0) AS r
) AS t
WHERE t.ran >= 3