Comparison Operators
- Comparison operators compare two expressions.
- The result of a comparison results to true or false.
- Comparison operators are not case sensitive and are used with text and dates as well as numbers.
Table 5. Comparison Operators
|
Operator
|
Description
|
|
=
|
Equal
|
|
<
|
Less than
|
|
>
|
Greater than
|
|
<=
|
Less than or equal to
|
|
>=
|
Greater than or equal to
|
|
<>
|
Not equal
|
|
!=
|
Not equal
|
Example:
USE world;
SELECT name, population
FROM country
WHERE population > 1000000;
Results:
