【SQL】180. Consecutive Numbers
标签：tin enum query time app weight div 面试 bsp
【SQL】180. Consecutive Numbers
# Write your MySQL query statement below
2 SELECT DISTINCT l1.Num AS ConsecutiveNums
3 FROM Logs AS l1,Logs AS l2,Logs AS l3
4 WHERE l1.Id+1=l2.Id AND l2.Id+1=l3.Id AND l1.Num=l2.Num AND l2.Num=l3.Num;