How to query integer Numbers have no value?

For example:
2,5,6,7,8,10,11,13,14,16... 10000

Not found in query 1 to 10000 Numbers:

1,3,4,9,12,15...

CodePudding user response:

First construct a sequence of 1-10000, then in the connections and the sequence in your example, matching is that there is no number of ah,
Tectonic sequence can use system table + row_number way, line is not enough or more than with the union all or row_number limit

CodePudding user response:

The maximum value is larger, 1001399999, how to quickly structure?