“查找连续出现的数字”
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200706110121298.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5NTQ4Njc4,size_16,color_FFFFFF,t_70#pic_center)
思路:连续出现意味着id连续,可将单表查询多次,然后用where条件组合。
注意:因为当连续个数超过三次时,输出结果会出现重复,所以用distinct关键字进行去重。
SELECT DISTINCT
l1.Num AS ConsecutiveNums
FROM
Logs l1,
Logs l2,
Logs l3
WHERE
l1.Id = l2.Id - 1
AND l2.Id = l3.Id - 1
AND l1.Num = l2.Num
AND l2.Num = l3.Num
;