Ansicht
Dokumentation

ABENLOOP_GROUP_BY_SORT_ABEXA - LOOP GROUP BY SORT ABEXA

- Grouping with LOOP and Sort

This example demonstrates how groupings are used for sorts.

Source Code

Execute

Description

In this example, the additions ASCENDING and DESCENDING of GROUP BY are used to sort a character-like table first while ignoring case and then sort within the groups to separate uppercase from lowercase. A further executable example shows how the LOOP statements can be replaced by a single expression.