【SQL】180. Consecutive Numbers
时间：2021-07-01 10:21:17
帮助过：46人阅读
# 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;
【SQL】180. Consecutive Numbers
标签：tin enum query time app weight div 面试 bsp
