Where Clause


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 ().