Operators

The following are the different type of operstors in db2 , generally these operators we are using in where clause for Condition checking.

1.Arithmetic Operators

2.Comparison Operators

3.Logical  Opertors

Arithmetic Operators:        –(Highst precedence)

+   ,  - , *,  /

Comparision  Operators:

              =(Equal)

              !=

               > (Greater than)

              <(Less than)

              >=(Greater or Equal)

              <= (Less Than or Equal)

              <> (Not Equal)

              between, not between

              in,  Not In 

              Null, Not Null

              Like

Logical Operators:

             AND,OR,NOT