Comparison Operators
Comparison operators are used to test single values in an SQL statement. The comparison operators discussed consist of =, <>, <, and >.
These operators are used to test
Equality
Non-equality
Less-than values
Greater-than values
Examples and the meanings of comparison operators are covered in the following sections.
Equality
The equal operator compares single values to one another in an SQL statement. The equal sign (=) symbolizes equality. When testing for equality, the compared values must match exactly or no data is returned. If two values are equal during a comparison for equality, the returned value for the comparison is TRUE; the returned value is FALSE if equality is not found. This Boolean value (TRUE/FALSE) is used ...
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
