Flash cards
Review the key moves
1/3
Core idea
What is the main idea behind SQL Operators?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Order
Put the learning moves in the order that makes the concept easiest to apply.
SQL Compound Operators
SQL Comparison Operators
SQL Arithmetic Operators
SQL operators are keywords and symbols used to perform operations with data values.
SQL operators are used in SQL statements like SELECT , WHERE , LIKE , etc.
SQL operators is categorized into the following types:
- Arithmetic operators
- Comparison operators
- Compound operators
- Bitwise operators
- Logical operators
SQL Arithmetic Operators
| Operator | Description | Example |
|---|---|---|
| + | Addition | |
| - | Subtraction | |
| * | Multiplication | |
| / | Division | |
| % | Modulus |
SQL Comparison Operators
| Operator | Description | Example |
|---|---|---|
| = | 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 Bitwise Operators
| Operator | Description |
|---|---|
| & | Bitwise AND |
| Bitwise OR | |
| ^ | Bitwise exclusive OR |
| ~ | Bitwise NOT |
SQL Logical Operators
| Operator | Description | Example |
|---|---|---|
| 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 |