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, you can write this query:
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 with 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, type:
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)
