每日一练-SQL题180

题目：

 

 

题解：  

        连续出现三次，且值相同。假设三张表：a,b,c。即a.Id=b.Id-1 and b.Id=c.Id-1 and a.Num=b.Num and b.Num=c.Num

SELECT distinct(a.Num) as ConsecutiveNums
FROM
    Logs a,
    Logs b,
    Logs c
WHERE
    a.Id = b.Id - 1
    AND b.Id = c.Id - 1
    AND a.Num = b.Num
    AND b.Num = c.Num