WITH Clause in Confluent Cloud for Apache Flink

Confluent Cloud for Apache Flink® enables writing auxiliary statements to use in larger SQL queries.

Syntax

WITH <with_item_definition> [ , ... ]
SELECT ... FROM ...;

<with_item_definition>:
   with_item_name (column_name[, ...n]) AS ( <select_query> )

Description

The WITH clause provides a way to write auxiliary statements for use in a larger query. These statements, often called Common Table Expressions (CTEs), are temporary views that exist for a single query.

Example

The following example defines a common table expression orders_with_total and uses it in a GROUP BY query.

WITH orders_with_total AS (
    SELECT order_id, price + tax AS total
    FROM orders
)
SELECT order_id, SUM(total)
FROM orders_with_total
GROUP BY order_id;