What is an Operator in SQL?
An operator is a symbol specifying an action that is performed on one or more expressions. The following tables lists the operator categories that SQL Server uses.
Arithmetic operators
Comparison operators
Logical operators
Set Operators
An operator is a symbol specifying an action that is performed on one or more expressions. The following tables lists the operator categories that SQL Server uses.
Arithmetic operators
Comparison operators
Logical operators
Set Operators
Operator Precedence ( * / + - )
Unary Operator A
unary operator has only one operand. +2 and
–5 are examples.
They have the format <operator
operand>.
Binary Operator Binary
operators have two operands. 5 + 4 and 7 x 5 are examples.
They have the format <operand1
operator operand2>.