# Operators¶

In this Topic:

## Arithmetic Operators¶

Operator Description
`a + b` Add two numeric expressions (number or real).
`+ a` Return a, which can cause implicit conversion of a to a numeric value.
`a - b` Subtract a numeric expression from another.
`- a` Negate the numeric input expression.
`a * b` Multiply two numeric expressions.
`a / b` Divide two numeric expressions.
`a % b` Compute the modulo of numeric expressions a per b.

## Comparison Operators¶

Operator Description
`a = b` a is equal to b.
`a != b` a is not equal to b.
`a <> b` a is less than or greater than b.
`a > b` a is greater than b.
`a >= b` a is greater than or equal to b.
`a < b` a is less than b.
`a <= b` a is less than or equal to b.

## Logical Operators¶

Logical operators return the result of a particular Boolean operation.

They can only be used as a predicate (e.g. in the WHERE clause). Input expressions must be predicates.

Operator Description
`a AND b` Matches both inputs.
`a OR b` Matches either input.
`NOT a` Does not match the input.