SQL——查找连续问题

2018-04-24  本文已影响0人  薛定谔与猫的故事
描述
# 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;
上一篇下一篇

猜你喜欢

热点阅读