sql 180. 连续出现的数字
                        
                            时间:2021-07-01 10:21:17
                            帮助过:29人阅读
							                        
                     
                    
                    
                     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