Database Reference
In-Depth Information
The query results appear in Figure 3-20.
85
Parts not in
warehouse 3
FIGURE 3-20
Query results
EXAMPLE 11
List the number, name, and balance of all customers with balances greater than or equal to $1,000 and less
than or equal to $5,000.
You could use a WHERE clause and the AND operator (Balance
1000 AND Balance
5000). An alter-
>¼
<¼
native to this approach uses the BETWEEN operator, as shown in Figure 3-21.
BETWEEN operator
indicates the value must
be between the listed
numbers
FIGURE 3-21
SQL query with the BETWEEN operator
