Database Reference
In-Depth Information
Table 6.3
Comparison Operators
Comparison Operator
Description
>
a
>
b, a is greater than b
<
a
<
b, a is less than b
>
=
a
>=
b, a is greater than or equal to b
<
=
a
<=
b, a is less than or equal to b
<>
a
<>
b, a is not equal to b
!
=
a !
=
a, a is not equal to b
Figure 6.24
Use
>=
comparison operator.
Figure 6.25
Use comparison operator on character string.
6.2.4 Arithmetic Operators
hese operators can perform mathematical operations on values of the numeric data type (Table 6.4).
To demonstrate the use of arithmetic operators, consider the following example that selects the
classrooms that have a capacity greater than or equal to 110% of the minimum capacity, which is
20 (Figure 6.26).
Some of the above operators can also be used with keywords such as UPDATE and DELETE.
For example, after the classrooms are remodeled in the building with the id 2, the capacities of its
