# Write your MySQL query statement below
select distinct a.Num as ConsecutiveNums
from Logs as a,Logs as b,Logs as c
where a.id = b.id-1 and b.id = c.id-1 and a.Num = b.Num and b.Num = c.Num;
# Write your MySQL query statement below
select distinct a.Num as ConsecutiveNums
from Logs as a,Logs as b,Logs as c
where a.id = b.id-1 and b.id = c.id-1 and a.Num = b.Num and b.Num = c.Num;
本文标题:SQL——查找连续问题
本文链接:https://www.haomeiwen.com/subject/grjslftx.html
网友评论