Decision Support Systems For Business Intelligence
    by Vicki L. Sauter

 
 

Table 3.3
Operators Possible in a “WHERE” clause

=
<> or !=

>=

<=
BETWEEN
IN

equal to
not equal to
greater than
greater than or equal to
less than
less than or equal to
between 2 values
an exact value, but you don’t know in which column

 

   Page Owner: Professor Sauter (Vicki.Sauter AT umsl.edu)