The SORT.SUP keyword suppresses the default sort by record id in the SHOW command.
The default action of the SHOW command if no sort clause is present is to show records sorted by record id. The SORT.SUP keyword suppresses this sort. It is useful where a sorted select list is being used to determine the records to be processed.
The keyword is ignored if the query includes a sort clause.
SELECT SALES BY CUSTOMER
SHOW SALES SORT.SUP
This command displays records in customer order.