[Excel]找出不連續編號

1.

2.選取範圍後再填入公式即可

[SQL]找出P Key不連續編號

select beginId,
(select min(id)-1 from table where id > beginId) as endId
from ( 
select id+1 as beginId from table
where id+1 not in
(select id from table)
and id < (select max(id) from table) 
) as t

參考資料：　https://hk.saowen.com/a/3af383a9bedac1adf87c3dd66fc912d13d90555368f1ea66077c42e802f14880