SAP SQL EXPR OVER NTILE ABEXA



Get Example source ABAP code based on a different SAP table
  



ABAP_SQLWIN - Window Function NTILE
This example demonstrates the window expression with the window function NTILE.

ABAP_SOURCE_CODE
DEMO CL_DEMO_SELECT_OVER_NTILE

ABAP_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).