Database Reference
In-Depth Information
Table 6.1
Logical Operators
Logical Operator
Description
AND
The data that meet both the search conditions connected by an
AND operator will be selected by the query.
OR
The data that meet at least one of the search conditions
connected by an OR operator will be selected by the query.
NOT
The data that do not meet the search condition speciied by a
NOT operator will be selected by the query.
BETWEEN
The data within the range speciied by a BETWEEN operator will
be selected by the query.
EXISTS
The data will be selected if a subquery in an EXISTS operator
returns any rows.
IN
If a value matches at least one of the values speciied by an IN
operation, the data corresponding to that value will be returned.
IS NULL
The data will be selected if a column in the search condition
contains any null (unknown) value.
LIKE
The data will be selected if a given value matches a speciic
pattern deined in a LIKE operator.
Figure 6.16
Use OR logical operator.
Figure 6.17
Use AND logical operator.
Search WWH ::




Custom Search