连续出现的数字

select distinct a.Num as ConsecutiveNums
from Logs as a,Logs as b,Logs as c
where a.Num=b.Num and b.Num=c.Num and a.id=b.id-1 and b.id=c.id-1;

原文地址:https://www.cnblogs.com/qianjinyan/p/14177509.html