They are used to compare two values. Their functions are shown in the table below
Operator | Relation tested | Example |
= | Equality | X = Y |
< > | Inequality | X<> Y |
< | Less than | X < Y |
> | Greater than | X > Y |
< = | Less than or equal to | X< = Y |
> = | Greater than or equation | X > = Y |
The hierarchy of the relational operation is =, >, <, <>, < = and >=