Ansicht
Dokumentation

ABENWITH_AGG_UNION_ABEXA - WITH AGG UNION ABEXA

WITH, Aggregation for Join Set

This example demonstrates how to use WITH for an aggregation.

Source Code

Execute

Description

This example has the same result as the executable example for a union with a global temporary table. The source code is almost identical. Here the global temporary table demo_sflight_agg has been replaced by a common table expression +agg and both SELECT statements are part of a WITH statement.