Generally in SQL operator means it is a symbol which specifies particular action that is performed on one or more expressions. Generally we will use these operators in SQL statements to perform logical or arithmetic or comparison operations.
In SQL we have different type of operators those are
- SQL Assignment Operators
By using these operators we can perform multiple operations like addition ( ), subtraction (-), division (/), multiply (*), modulo (%) on SQL statements.
By using logical operators we can do multiple operations like checking SQL statements based on some conditions like AND, OR, EXISTS, BETWEEN, etc… and comparison of multiple values in SQL statements.
These operators are used to assign required values to variables. In assignment operators we have only one equal (=) operator available.
Generally these operators is used to compare multiple expressions based on conditions using operators like Equals to (=), Greater than (>), Less than (<), Not equal to (<>), etc….