出现几次就创建几次自联结
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;
但这种方法效率不高
查找所有至少连续出现三次的数字
最新推荐文章于 2024-05-07 18:00:00 发布
出现几次就创建几次自联结
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;
但这种方法效率不高