SQL has operators for evaluations.
Arithmetic
| Operator | Name |
|---|---|
| + | Addition |
| - | Subtraction |
| ** | Multiplication |
| / | Division |
| % | Modulus |
Comparison
| Operator | Name |
|---|---|
| < | Less than |
| > | Greater than |
| = | Equals |
| ⇐ | Less than or equals |
| >= | Greater than or equals |
| <> | Not equal to |
Logical
| Operator |
|---|
| ALL |
| AND |
| ANY |
| BETWEEN |
| EXISTS |
| UNION |
| IN |
| LIKE |
| NOT |
| OR |
| SOME |