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
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>.
