=
|
Equal
|
<> or !=
|
Not equal.
|
>
|
Greater than
|
<
|
Less than
|
>=
|
Greater than or equal
|
<=
|
Less than or equal
|
BETWEEN
|
Between an inclusive range
|
LIKE
|
Search for a pattern
|
IN
|
To specify multiple possible values for a column
|
AND
|
Display result if (all) conditions are true.
|
OR
|
To display result if either of conditions is true.
|
NOTBETWEEN
|
Not between an inclusive range
|