Hi I have table with data in sql But I want find missing number from tableIdNamePeopleAddressRecieptNumber1Pulodov Rustamcity Dushanbe17782Soliev Firuzcity H

Hi PRARefer below linkSelect missing number from a column using while loop in SQL Server

Get missing record from column using while loop in SQL Server

PRA

Hi! I have table with data in sql. But I want find missing number from table.

Here missing recieptnumber 1980 and 1983. Every day I insert data into table. I want query get missing recieptnumber.

Output result:

1980

1983

Because hasn't it in order.

dharmend...

0 2

Hi PRA,

Refer below link.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html