Conditional Statements
Conditional Statements
Conditional statements are used in both the FROM and WHERE clauses. The most common operator is the equals ‘=’ sign however there are others that can be used as well. There are a few types of conditional statements. The first is the normal logical group of equals ‘=’, not equals ‘<>’ or ‘!=’, less than ‘<’, greater than ‘>’, less than or equal to ‘<=’, and greater than or equal to ‘>=’. These statements are similar to those found in programming languages or applications such as Excel.
| Operator | SQL Syntax | Description |
| = | field1 = field2 | field1 must equal field2 |
| <> or != | field1 <> field2 | field1 must not equal field2 |
| > | field1 > field2 | field1 is greater than field2 |
| >= | field1 >= field2 | field1 is greater than or equal to field2 |
| < | field1 < field2 | field1 is less than field2 |
| <= | field1 <= field2 | field1 is less than or equal to field2 |
