Kontakt

Ansicht
Dokumentation

ABENSQL_EXPR_OVER_LEAD_LAG_ABEXA - SQL EXPR OVER LEAD LAG ABEXA

ABENSQL_EXPR_OVER_LEAD_LAG_ABEXA - SQL EXPR OVER LEAD LAG ABEXA

BAL Application Log Documentation   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

- Window Functions LEAD and LAG

This example demonstrates window expressions with the window functions LEAD and LAG.

Source Code

Execute

Description

The example shows results of the window functions LEAD and LAG to which all three possible arguments are passed. Like in the executable example, the windows are determined for window expressions with sorting.

  • The first argument determines the result as a character-like representation of the column NUM1 of the row determined by the second argument.
  • The second argument determines the rows to be evaluated using differently sized distances.
  • The third argument is a literal returned instead of the null value if the row to be evaluated is not in the current window.





Addresses (Business Address Services)   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 1486 Date: 20240419 Time: 074007     sap01-206 ( 15 ms )