- 连续出现的数字
思路:主要是对连续数字的统计,首先要得到连续的num出现三次且值相等,注意是连续,然后查询的结果需要去重(连续出现说明id也是连续的)
实现代码:
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
思路:主要是对连续数字的统计,首先要得到连续的num出现三次且值相等,注意是连续,然后查询的结果需要去重(连续出现说明id也是连续的)
实现代码:
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