sql - 如何找到最小的缺失序列号

我有一张有序列号的表。

我想找到缺失数字中最小的缺失序列号。

For eg.,

Seq No: 1,2,3,5,7,9 ==> Expected result: 4
Seq No: 1,2,3,4,5,6,7,9,15 ==> Expected result: 8

最佳答案

你可以试试 row_number()

with cte as
(
select seq,seq-row_number() over(order by seq) as diff
from tablename
)
select * from cte where diff<>0 and diff in (select min(diff) from cte where diff<>0)

关于sql - 如何找到最小的缺失序列号，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/55215038/