how to find missing sequence or gap in sql

thank you all of you for your suggestion....

this is my serial no this n no of data how to fine in this gap number

161630009443

161630009463
161630009464
161630009465
161630009466
161630009446

Hi,

Try below query -

Reference :

https://www.xaprb.com/blog/2005/12/06/find-missing-numbers-in-a-sequence-with-sql/

In SQL Server:

For SQL other DB's refer the following Link : https://stackoverflow.com/questions/1312101/how-do-i-find-a-gap-in-running-counter-with-sql

pls check this link https://stackoverflow.com/questions/10968493/how-to-check-any-missing-number-from-a-series-of-numbers