sql 180. 连续出现的数字

distinct logs.Num as ConsecutiveNums from logs as logs1,logs as logs2 ,logs where logs.id=logs1.id-1 and logs.id=logs2.id-2 and logs.Num=logs1.Num and logs.Num=logs2.Num

 

sql 180. 连续出现的数字

标签：编写   and   练习   sele   div   查找   多表   nbsp   sel