Equalities and inequalities

You can use an equal sign (=), various inequality symbols, and the NOT keyword to specify search conditions in the WHERE clause.

How to test for equality
You can use an equal sign (=) to select rows for which a specified column contains a specified value.
How to test for inequalities
You can use inequality operators to specify search conditions in your SELECT statements.
How to test for equality or inequality in a set of columns
You can use the equal operator or the not equal operator to test whether a set of columns is equal or not equal to a set of values.
How to test for a false condition
You can use the NOT keyword to test for a false condition.

Parent topic: Ways to filter the number of returned rows

Related tasks

Using predicates efficiently

Related reference

Basic predicate
where-clause