用用户变量记录出现次数即可~
select distinct NUM from(
select NUM, @count := if(@prevNum = NUM, @count + 1, 1) as cnt, @prevNum := NUM
from Logs, (select @prevNum := NULL) pn, (select @count := 0) ct
order by Id asc) t
where cnt >= 3;
用用户变量记录出现次数即可~
select distinct NUM from(
select NUM, @count := if(@prevNum = NUM, @count + 1, 1) as cnt, @prevNum := NUM
from Logs, (select @prevNum := NULL) pn, (select @count := 0) ct
order by Id asc) t
where cnt >= 3;