Ansicht
Dokumentation

ABENSQL_EXPR_OVER_NTILE_ABEXA - SQL EXPR OVER NTILE ABEXA

ABENSQL_EXPR_OVER_NTILE_ABEXA - SQL EXPR OVER NTILE ABEXA

BAL_S_LOG - Application Log: Log header data   CPI1466 during Backup  
This documentation is copyright by SAP AG.
SAP E-Book

- Window Function NTILE

This example demonstrates the window expression with the window function NTILE.

Source Code

Execute

Description

All employees from the DEMO_EMPLOYEES table are sorted by their salary, starting with the lowest, and distributed into five salary groups by the NTILE function. The first group, group 1, has one entry more than the other four groups, as the number of employees (11) cannot be distributed equally into the number of buckets (five in this example).






Vendor Master (General Section)   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 878 Date: 20240328 Time: 131322     sap01-206 ( 21 ms )