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:
End-of-Chapter Survey
: How would you rate the overall quality of this chapter?- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality