SQL练习笔记四：连续出现的数字

CREATE TABLE Log(
  Id int(4) not null,
  num int(4) not null
);

INSERT INTO Log VALUES(1,1);
INSERT INTO Log VALUES(2,1);
INSERT INTO Log VALUES(3,1);
INSERT INTO Log VALUES(4,2);
INSERT INTO Log VALUES(5,1);
INSERT INTO Log VALUES(6,2);
INSERT INTO Log VALUES(7,2);
INSERT INTO Log VALUES(8,2);

-- 创建3个Log表副本L1,L2,L3 通过Id连续相比且num相等实现 --
SELECT DISTINCT
  L1.num AS ConsecutiveNums 
FROM
  Log AS L1,
  Log AS L2,
  Log AS L3 
WHERE
  L1.Id = L2.Id - 1 
  AND L2.Id = L3.Id - 1 
  AND L1.num = L2.num 
  AND L2.num = L3.num;