Developing By Me

Project Development and Design

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

 

%d bloggers like this: