1.6
Comparison Operators
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:
