A newer version of this documentation is available.

View Latest

Operators Overview

  • reference
    +
    Operators perform a specific operation on the input values or expressions.

    SQL++ provides a full set of operators that you can use within its statements. Here are the categories of SQL++ operators:

    Operator Precedence

    SQL++ supports the use of parentheses to group operators and expressions. Expressions enclosed in parentheses are evaluated first.

    The following table shows operator precedence level. An operator at a higher level is evaluated before an operator at a lower level.

    Evaluation Order Operator

    1

    CASE

    2

    . (period)

    3

    [ ] (left and right bracket)

    4

    - (unary)

    5

    * (multiply), / (divide), % (modulo)

    6

    +, - (binary)

    7

    IS

    8

    IN

    9

    BETWEEN

    10

    LIKE

    11

    < (less than, <= (less than or equal to, > (greater than), and => (equal to or greater than)

    12

    = (equal to) , == (equal to), <> (less than or greater than), != (not equal to)

    13

    NOT

    15

    AND

    16

    OR