Operators are the special keywords or special characters reserved for performing particular operations and are used in the SQL queries. There is three type of operators used in SQL:
- Arithmetic operators: addition (+), subtraction (-), multiplication (*), division (/), etc.
- Logical operators: ALL, AND, ANY, ISNULL, EXISTS, BETWEEN, IN, LIKE, NOT, OR, UNIQUE.
- Comparison operator: =, !=, <>, <, >, <=, >=, !<, !>