SQL Operators
Perform operations like calculations, comparisons, and logical checks.
🡆Enable filtering, calculating, and updating data in databases.
🡆Essential for query optimization and accurate data management.
SQL Arithmetic Operators:Arithmetic operators in SQL are used to perform mathematical operations on table data. These operators help in calculating totals, differences, percentages, and other numeric transformations directly in queries.
Operator Description
+ Addition
– Subtraction
/ Division
* Multiplication
% Modulus (Remainder)
SQL Bitwise Operators:Bitwise operators in SQL are used to perform bitwise operations on binary values in SQL queries, manipulating individual bits to perform logical operations at the bit level.
Operator Description
& Bitwise AND
| Bitwise OR
^ Bitwise exclusive OR
SQL Comparison Operators:SQL Comparison Operators are used to compare two values and filter the result set based on a specific condition.
Operator Description
= Equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
<> Not equal to
SQL Compound Operators:Compound operators combine an operation with assignment. These operators modify the value of a column and store the result in the same column in a single step.
Operator Description
+= Add equals
-= Subtract equals
*= Multiply equals
/= Divide equals
%= Modulo equals
&= Bitwise AND equals
^= Bitwise exclusive equals
|*= Bitwise OR equals
SQL Logical Operators :SQL Logical Operator used to combine or manipulate conditions in SQL queries to retrieve or manipulate data based on specified criteria.
Operator Description
ALL TRUE if all of the subquery values meet the condition
AND TRUE if all the conditions separated by AND is TRUE
ANY TRUE if any of the subquery values meet the condition
BETWEEN TRUE if the operand is within the range of comparisons
EXISTS TRUE if the subquery returns one or more records
IN TRUE if the operand is equal to one of a list of expressions
LIKE TRUE if the operand matches a pattern
NOT Displays a record if the condition(s) is NOT TRUE
OR TRUE if any of the conditions separated by OR is TRUE
SOME TRUE if any of the subquery values meet the condition