180. Consecutive Numbers

SELECT DISTINCT l1.Num AS ConsecutiveNums
FROM Logs l1,Logs l2,Logs l3
WHERE l1.Id = l2.Id-1 AND l1.Id = l3.Id-2
AND l1.Num =l2.Num AND l1.Num=l3.Num;

posted @ 2018-12-20 02:56  yuesi  阅读(90)  评论(0编辑  收藏  举报