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