Leetcode 180 连续出现的数字

题目: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