The where clause is the part of the select statement that is used to filter the result set. The following conditional operators can be used to compare values in the where clause.
= Equal to
<> Not equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
between ... and ... >= and <= the values before and after and respectively
in (1,2,3) Equal to one of the values in the brackets
not in (1,2,3) Not equal to one of the values in the brackets
is null field is empty
is not null field is not empty
A where clause can contain multiple conditions that are grouped using and and or. Care must be taken to group the conditions correctly using round brackets ().