In the following example, only data with an Order ID from 10000 to 10500 (inclusive) will pass the filter and be acted upon by the query.
To filter one column in the table for a range of data that falls on or between the low value and high value that you specify, use BETWEEN. To search for values outside this range, use NOT BETWEEN.
In the following example, only data with an Order ID from 10000 to 10500 (inclusive) will pass the filter and be acted upon by the query.