编写一个 SQL 查询,查找所有至少连续出现三次的数字。
思路:连续查该表三次,这三次查了连续的三个数字,若这三次查到的是同一个数字,则认为查到了
代码如下:
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 ;
结果:
编写一个 SQL 查询,查找所有至少连续出现三次的数字。
思路:连续查该表三次,这三次查了连续的三个数字,若这三次查到的是同一个数字,则认为查到了
代码如下:
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 ;
结果: