其思想是减去一个递增值，然后进行合计：

select min(log_id), max(log_id)
from (
    select t.*, row_number() over (order by log_id) as seqnum
    from t
) t
group by (log_id - seqnum)
order by min(log_id);

您可以使用row_number()，尝试以下操作，这里是演示。

select
    min(log_id) as start_id,
    max(log_id) as end_id
from
(
    select
        log_id,
        log_id - row_number() over (order by log_id) as rnk
    from logs
) t
group by
    rnk

你也可以创建CTE-

With CTE AS(
select log_id,
log_id-row_number() over(order by log_id) as diff from logs)

Select MIN(log_id) as start_id,MAX(log_id) as end_id from CTE group by diff
ORDER by start_id