Databases Reference
In-Depth Information
The query results appear in Figure 3-19.
83
Parts not in
warehouse 3
FIGURE 3-19
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 alterna-
tive to this approach uses the BETWEEN operator, as shown in Figure 3-20.
BETWEEN operator
indicates the value must
be between the listed
numbers
FIGURE 3-20
SQL query with the BETWEEN operator
