Hi I have table with data in sql But I want find missing number from tableIdNamePeopleAddressRecieptNumber1Pulodov Rustamcity Dushanbe17782Soliev Firuzcity Hisor17793Sharipov Sadriddincity Dushanbe19814Asrori Yatimcity Kulob19825Mallaev Nurullocity Dushanbe1984Here missing recieptnumber 1980 and 1983 Every day I insert data into table I want query get missing recieptnumberOutput result19801983Because hasnt it in order

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