连续出现的数字

 

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;

 

 

posted @   巴黎爱工作  阅读(97)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示