力扣180--oracle--连续出现的数字

?

1 2 3 4 5 6 7 8

Create table Logs (id int, num int); insert into Logs (id, num) values (1, 1); insert into Logs (id, num) values (2, 1); insert into Logs (id, num) values (3, 1); insert into Logs (id, num) values (4, 2); insert into Logs (id, num) values (5, 1); insert into Logs (id, num) values (6, 2); insert into Logs (id, num) values (7, 2);

编写一个 SQL 查询，查找所有至少连续出现三次的数字,返回的结果表中的数据可以按 任意顺序 排列,期望得到的结果

 答案

?

1 2 3 4 5 6 7

with t as (select id, num, row_number() over(order by id) - row_number() over(partition by Num order by id) as gp from logs) select distinct num as ConsecutiveNums from t group by gp, num having count(num) >= 3

　理解下面代码的输出结果