Databases Reference
In-Depth Information
The query results appear in Figure 3-4.
All fields are
included
76
FIGURE 3-4
Query results
EXAMPLE 4
List the name of every customer with a $10,000 credit limit.
You include the following condition in the WHERE clause to restrict the query results to only those cus-
tomers with a credit limit of $10,000.
WHERE CreditLimit=10000
Notice that you do not type commas or dollar signs in numbers. The query design appears in Figure 3-5.
Condition (credit limit
must be $10,000)
FIGURE 3-5
SQL query with WHERE condition
