Ansicht
Dokumentation

ABENSQL_EXPR_OVER_ABEXA - SQL EXPR OVER ABEXA

- Window Expressions

This example demonstrates simple window expressions.

Source Code

Execute

Description

The example demonstrates how different window functions are applied to windows of a result set of a query defined using PARTITION. The content of the columns CHAR1 and CHAR2 is used as a window criterion. All rows that have identical content in these columns form a window. The result of a window function for a row is determined from all rows of the window this row is a part of. The final column perc demonstrates how a window function can be used as arguments of an SQL expression and hence produce row-dependent results, in this case the percentage of the value of the column NUM1 as part of the entire window.