方法一:
内连接:
# Write your MySQL query statement below
SELECT DISTINCT L1.Num AS ConsecutiveNums
FROM Logs L1,Logs L2,Logs L3
WHERE L1.Num=L2.Num AND
L1.Id+1=L2.Id AND
L2.Num=L3.Num AND
L2.Id+1=L3.Id
;
方法二:
join:
# Write your MySQL query statement below
SELECT DISTINCT L1.Num AS ConsecutiveNums
FROM Logs L1
JOIN Logs L2 ON L1.Num=L2.Num AND L1.Id+1=L2.Id
JOIN Logs L3 ON L2.Num=L3.Num AND L2.Id+1=L3.Id
;