Ansicht
Dokumentation

ABENWITH_CTE_ABEXA - WITH CTE ABEXA

WITH, Common Table Expressions

This example demonstrates how common table expressions are used in the statement WITH.

Source Code

Execute

Description

A common table expression +conns creates a table of flight connections. A further expression, +cnts, determines the number of entries in the result set of +conns. The closing main query combines the result sets of both common table expressions using a cross join. This makes available the number of entries in every row of the result set of the WITH statement. The common table expression +conns is used twice in the WITH statement.