Hello Good Sql pals,
Lets say I have like 3000 records or receipts arranged in order of receipt number e.g. receipt 20001 to receipt 23001.
Now receipt 22991, receipt 21222 and receipt 22456 are missing. How can I write a Sql query that will pick out the missing receipts?
Or how will I query the points where the sequence is broken?