题目地址:https://leetcode.com/problems/consecutive-numbers/
题解:这题很简单,直接暴力查询。
select distinct l1.Num as ConsecutiveNums
from Logs l1,Logs l2,Logs l3
where l1.Id+1=l2.Id and l2.Id+1=l3.Id
and l1.Num=l2.Num and l2.Num=l3.Num;
题目地址:https://leetcode.com/problems/consecutive-numbers/
题解:这题很简单,直接暴力查询。
select distinct l1.Num as ConsecutiveNums
from Logs l1,Logs l2,Logs l3
where l1.Id+1=l2.Id and l2.Id+1=l3.Id
and l1.Num=l2.Num and l2.Num=l3.Num;