HP QUERY, Справочное руководство, Страница: 148 / 280

REPORT
DES indicates that the data item v alues are to b e ordered in descending order.
The following sort statement sorts the en tries in to the order sp ecied b y the v alue of
L-NAME.
S1,L-NAME
DATA ENTRIES AFTER FIND
L-NAME F-NAME AGE
WHITE ROB 26
BROWN JACK 32
GREEN ROB 49
WHITE LARRY 81
BROWN CHRIS 17
GREEN SAM 28
GREEN BILL 45
BROWN DAN 39
WHITE WILL 22
DATA ENTRIES AFTER SORT EXECUTED
L-NAME F-NAME AGE
BROWN JACK 32
BROWN CHRIS 17
BROWN DAN 39
GREEN ROB 49
GREEN SAM 28
GREEN BILL 45
WHITE ROB 26
WHITE LARRY 81
WHITE WILL 22
The higher-n um b ered sort statement iden ties the ma jor (or rst) sort eld, while the
low er-n um b ered sort statement iden ties the minor sort eld. The minor sort arranges en tries
in the order sp ecied, k eeping all ma jor sort items with iden tical v alues together, in other
w ords, it sorts within subsets of the en tire set of en tries.
S1,F-NAME
S2,L-NAME
If the statements ab o v e app ear in a rep ort, the result w ould b e as follows.
L-NAME F-NAME AGE
level 2 (major)--> BROWN level 1 (minor) --> CHRIS 17
Contr ol br e ak BROWN c ontr ol br e aks DAN 39
BROWN JACK 32
level 2 (major)--> GREEN BILL 45
c ontr ol br e ak GREEN ROB 49
GREEN SAM 28
level 2 (major)--> WHITE LARRY 81
3-112 QUERY/V COMMANDS