Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

SQL Operators

SQL Arithmetic Operators

Operator

Description

+

Add

Subtract

*

Multiply

/

Divide

%

Modulo

SQL Bitwise Operators

Operator

Description

&

Bitwise AND

|

Bitwise OR

^

Bitwise exclusive OR

SQL Comparison Operators

Operator

Description

=

Equal to

Greater than

Less than

>=

Greater than or equal to

<=

Less than or equal to

<> 

Not equal to

SQL Compound Operators

Operator

Description

+=

Add equals

-=

Subtract equals

*=

Multiply equals

/=

Divide equals

%=

Modulo equals

&=

Bitwise AND equals

^-=

Bitwise exclusive equals

|*=

Bitwise OR equals

SQL Logical Operators

Operator

Description

ALL

The condition returns TRUE only if all values from the subquery satisfy the requirement.

AND

The result is TRUE only when all conditions joined by AND are TRUE.

ANY

The condition returns TRUE if at least one value from the subquery satisfies the requirement.

BETWEEN

The condition returns TRUE if the operand falls within the range of comparisons.

EXISTS

The condition returns TRUE if the subquery yields one or more records.

IN

The condition returns TRUE if the operand matches any of the expressions in a provided list.

LIKE

The condition returns TRUE if the operand conforms to a specified pattern.

NOT

Display a record if the condition(s) is FALSE.

OR

The result is TRUE if any of the conditions joined by OR are TRUE.

SOME

The condition returns TRUE if any of the values from the subquery satisfy the requirement.