答案:
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;
答案:
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;
转载于:https://my.oschina.net/daxin/blog/1823048