In sql, operator is a symbol which is used to specify a particular action that is performed on one or more expressions. Generally, we will use these operators in SQL statements to perform a logical or arithmetic or comparison operations.
In SQL we have different type of operators available, those are
In sql, arithmetic operators are used to perform multiple operations like addition ( ), subtraction (-), division (/), multiply (*), modulo (%) on sql statements.
To know more about arithmetic operators, check this SQL Arithmetic Operators with Examples.
In sql, logical operators are used to perform multiple operations like checking sql statements based on some conditions like AND, OR, EXISTS, BETWEEN, etc… and comparison of multiple values in SQL statements.
To know more about logical operators, check this SQL Logical Operators with Examples.
In sql, assignment operators are used to assign a required values to variables. In assignment operators we have only one equal (=) operator available.
In sql, comparision operators are used to compare multiple expressions based on defined conditions using operators like Equals to (=), Greater than (>), Less than (<), Not equal to (<>), etc.
To know more about comparision operators, check this SQL Comparison Operators with Examples.