Database Reference
In-Depth Information
Figure 6.18
Use BETWEEN logical operator.
Figure 6.19
Use IN logical operator.
here is only one row that matches both conditions of the AND operator.
he example in Figure 6.18 uses the BETWEEN operator to deine the grade range between A
and C. he information is about students who have earned the grade C or better.
he next example shows the use of the IN operator. Like the OR operator, if a value matches
one of the values speciied by the IN operator, the data corresponding to that value will be selected.
In Figure 6.19, classes enrolled by a list of students speciied by the IN operator are selected.
Six rows are selected; two rows match the search condition StudentID 11 and the other four
rows match the search condition StudentID 10.
he LIKE operator is often used with wildcard operators. he common wildcard operators are
shown in Table 6.2.
Figure 6.20 shows how to use a wildcard operator with an example that selects students whose
last names start with a letter between A and D.
