Ansicht
Dokumentation
ABENSQL_EXPR_OVER_NTILE_ABEXA - SQL EXPR OVER NTILE ABEXA
BAL_S_LOG - Application Log: Log header data CPI1466 during BackupThis documentation is copyright by SAP AG.
- Window Function NTILE
This example demonstrates the window expression with the window function NTILE.
Source Code
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 )