WHERE Clause Operators...........

WHERE Clause Operators:

 


   Following are where clause operators.


 
 
=
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