Database Reference
In-Depth Information
The query results appear in Figure 3-5.
78
All ields are
included
FIGURE 3-5
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
customers 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-6.
Condition (credit limit
must be $10,000)
FIGURE 3-6
SQL query with a WHERE condition
