Parenthesized expression

Parentheses can be used to enforce a particular order of evaluation in expressions that contain multiple operators.

Use a parenthesized expression to explicitly specify the order of operations in a complex arithmetic expression.

Empty parentheses are used to denote an empty sequence.

Syntax

parenthesized-expression
Read syntax diagramSkip visual syntax diagram(expression)

Examples

In the following example, the parenthesized expressions 5+5 and 6+4 are evaluated first.
SELECT XMLQUERY (' ((5+5) * (6+4)) div 5') FROM T1
The result is 20.