The current webpage provides an overview of SQL operators, which are used to perform operations in SQL queries. Here’s a concise summary:
- Arithmetic Operators: Used for mathematical calculations, including addition (+), subtraction (-), multiplication (*), division (/), and modulo (%).
- Bitwise Operators: Work at the bit level, such as AND (&), OR (|), and exclusive OR (^).
- Comparison Operators: Used to compare values, such as equal to (=), greater than (>), less than (<), greater than or equal to (>=), less than or equal to (<=), and not equal to (<>).
- Compound Operators: Combine arithmetic and assignment, like +=, -=, *=, /=, %=, plus bitwise equals (&=, ^=, |=).
- Logical Operators: Used to combine multiple conditions in queries, including ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR, and SOME.
Each operator category provides examples and brief descriptions, helping users understand their usage in SQL statements. The page also includes interactive “Try it” links for practicing these operators directly in an online SQL editor.[1]
1
SQL Arithmetic Operators
| Operator |
Description |
| + |
Add |
| - |
Subtract |
| * |
Multiply |
| / |
Divide |
| % |
Modulo |
SQL Bitwise Operators
| Operator |
Description |
| & |
Bitwise AND |
| | |
Bitwise OR |
| ^ |
Bitwise exclusive OR |
SQL Comparison Operators
| Operator |
Description |
| = |
Equal to |
| > |
Greater than |
| < |
Less than |
| >= |
Greater than or equal to |
| <= |
Less than or equal to |
| <> |
Not equal to |
SQL Compound Operators
| Operator |
Description |
| += |
Add equals |
| -= |
Subtract equals |
| *= |
Multiply equals |
| /= |
Divide equals |
| %= |
Modulo equals |
| &= |
Bitwise AND equals |
| ^= |
Bitwise exclusive equals |
| |*= |
Bitwise OR equals |
SQL Logical Operators
| 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 |