SQL練習(xí)筆記四：連續(xù)出現(xiàn)的數(shù)字

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);

-- 創(chuàng)建3個(gè)Log表副本L1,L2,L3 通過(guò)Id連續(xù)相比且num相等實(shí)現(xiàn) --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;