Ranges (between and not between)

Use the between keyword to specify an inclusive range.

For example, to find all the books with sales between and including 4095 and 12,000, use:

select title_id, total_sales 
from titles 
where total_sales between 4095 and 12000 
title_id  total_sales 
------    -----------
BU1032           4095 
BU7832           4095 
PC1035           8780 
PC8888           4095 
TC7777           4095 
 
(5 rows affected) 

You can specify an exclusive range using the greater than (>) and less than (<) operators:

select title_id, total_sales 
from titles 
where total_sales > 4095 and total_sales < 12000 
title_id  total_sales 
------    -----------
PC1035           8780 
 
(1 row affected)

not between finds all rows outside the specified range. To find all the books with sales outside the 4095 to 12,000 range, enter:

select title_id, total_sales 
from titles 
where total_sales not between 4095 and 12000
title_id     total_sales 
--------     -----------
BU1111              3876 
BU2075             18722 
MC2222              2032 
MC3021             22246 
PS1372               375 
PS2091              2045 
PS2106               111 
PS3333              4072 
PS7777              3336 
TC3218               375 
TC4203             15096 
 
(11 rows affected)