WITH Clause

    or

    1. WITH <identifier> AS <subquery expression>

    Examples

    Example 2: Evicting a sum(bytes) expression result from the SELECT clause column list

    2.     formatReadableSize(s),
    3.     table
    5. ORDER BY s;

    Example 4: Reusing expression in a subquery

    1. WITH test1 AS (SELECT i + 1, j + 1 FROM test1)