SQL Operators

SQL Operators 

An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s), such as comparisons and arithmetic operations. These Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.

SQL Arithmetic Operators

OperatorsDescription
+

Add

-

Subtract

*

Multiply

/

Divide

%

Module



SQL Comparison Operators

OperatorsDescription

Equal to

>Greater than

<

Less than

>=

Greater than or equal to

<=

Less than or equal to

<>

Not equal to



SQL Compound Operators

OperatorsDescription
+=

Add equals

-=Subtract equals

*=

Multiply equals

/=

Divide equals

%=

Module equals

&=

Bitwise AND equals

^-=
Bitwise exclusive equals
|*=
Bitwise OR equals


SQL Logical Operators

OperatorsDescription
ALL

TRUE if all of the subquery values meet the condition

ANDTRUE if all the conditions separated by AND is TRUE

ANY

TRUE if any of the subquery values meet the condition

BETWEEN

TRUE if the operand is within the range of comparisons

EXISTS

TRUE if the subquery returns one or more records

IN

TRUE if the operand is equal to one of a list of expressions

LIKE
TRUE if the operand matches a pattern
NOT
Displays a record if the condition(s) is NOT TRUE
OR
TRUE if any of the conditions separated by OR is TRUE
SOME
TRUE if any of the subquery values meet the condition


SQL Bitwise Operators

OperatorsDescription
&

Bitwise AND

|

Bitwise OR

^

Bitwise exclusive OR