[SQL]consecutive-numbers

https://leetcode.com/problems/consecutive-numbers

Consecutive Numbers - LeetCode

with base as (
    select
        num 
        , lag(num, 1) over (order by id) rn1
        , lag(num, 2) over (order by id) rn2
    from logs
)
select
    distinct num as 'ConsecutiveNums'
from base
where num = rn1 and rn1 = rn2