Hi there.
I am trying for a query which helps in finding the first missing number within the sequence of number in a database. Consider the example that , I have a set of fields which may are having the numbers from 1-10 and number missing 11, have the numbers from 12-15, and missing 16, and similar kind.
I want to perform through the table and explain that 11 as a number is the first number missing out of the sequence of number. This is regarding for an issue of employee numbers in standard order, but in the past there were problems at random so I am trying to clear it out and issue all the missing numbers. So when each time I will run the query, it will find the next lowest missing number.
Please help me with this.
Bookmarks