WITH Clause

1. Recursive queries are not supported.
2. Expression’s results are not available in subqueries.

Examples

Example 1: Using constant expression as “variable”

Example 3: Using results of scalar subquery

As a workaround for current limitation for expression usage in subqueries, you may duplicate it.