- Arithmetic Operators
- Comparison Operators
- Logical Operators
SQL Arithmetic Operators
| Addition | +, add two value |
| Subtraction | -, Subtracts right hand operand from left hand operand. |
| Multiplication | *, Multiply two value |
| Division | /, Divides left hand operand by right hand operand |
| Modulus | % , Divides left hand operand by right hand operand and returns the remainder |
SQL Comparison Operators
| < | Less than |
| > | Greater than |
| <= | Less than or equal |
| >= | Greater than or equal |
| = | Equal |
| != | Not equal |
| <> | Not equal |
| !< | Not less than |
| >! | Not greater than |
SQL Logical Operators
| ALL | |
| ANY | |
| AND | |
| OR | |
| IN | |
| BETWEEN | |
| EXISTS | |
| LIKE | |
| NOT | |
| UNIQUE | |
| IS NULL |