<div>
SELECT *<br />
FROM tblRange<br />
WHERE n &gt;&nbsp;intStart AND n &lt;&nbsp;intEnd<br />
<br />
If records are returned n is in that record's range. &nbsp;if no records are returned it lies outside all the ranges.
</div>


SELECT *
FROM tblRange
WHERE n > intStart AND n < intEnd

If records are returned n is in that record's range.  if no records are returned it lies outside all the ranges.

<div>
<div class="content wysiwyg-content">
Is there an easy way to determine if a given integer is not within a set of ranges of integers? &nbsp;I have a table - tblRange with columns intStart and intEnd. &nbsp;Each record in tblRange consists of records similar to this: intStart = 5, intEnd = 10; intStart = 1, intEnd = 6; intStart = 11, intEnd = 20, etc. &nbsp;For each record, intStart is always &gt;= intEnd and intStart &gt;= 0. &nbsp;Given n, how can determine if n does not lie within (inclusive) any of tblRange's records ranges?
</div>
</div>


Is there an easy way to determine if a given integer is not within a set of ranges of integers?  I have a table - tblRange with columns intStart and intEnd.  Each record in tblRange consists of records similar to this: intStart = 5, intEnd = 10; intStart = 1, intEnd = 6; intStart = 11, intEnd = 20, etc.  For each record, intStart is always >= intEnd and intStart >= 0.  Given n, how can determine if n does not lie within (inclusive) any of tblRange's records ranges?

SQL - determine if a given number does not lie within any range of numbers within a set of ranges

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.