Ansicht
Dokumentation

ABENSQL_EXP_PARENTHESES - SQL EXP PARENTHESES

- ( )

... ( sql_exp ) ...

Every full SQL expression sql_exp can be enclosed in parentheses ( ... ). There must be a blank after the opening parenthesis and in front of the closing parenthesis. Parenthesis affect the priority with which expressions are evaluated. Parenthesis levels are evaluated from inside out and from left to right. The result of a parenthesis is the result of the outermost expression in the parenthesis.

Notes

• Using parentheses always means specifying an SQL expression. Parentheses can only be used for operand positions for which SQL expressions are possible. This particularly applies to placing parentheses around elementary SQL expressions. Without parentheses, they can also be used in specific operand positions in which no SQL expressions are possible.

• Parentheses are used especially in arithmetic expressions to affect the priority of calculations.

Example

Parenthesizing of a subtraction as the dividend in a division.