Support : Dialog Search Aids : Successful Searching : SORT : Descending Order Option

SORT (continued)

Descending Order Option

To specify that a sorted set be in descending order, enter a comma and the letter D after the sort field (e.g., SORT S9/ALL/SL,D). Descending order is most often used with fields of numeric or financial data in order to arrange output from the highest to the lowest. Alphabetical fields sorted in descending order will come out arranged Z to A. If you do not specify descending order, the field is sorted in ascending order. Text fields are arranged alphabetically A to Z, and numeric fields are arranged from lowest to highest.

• To SORT by Sales (SL) in descending order (,D):

File 562:ICC Brit.Co.Finan.Data 2008/Mar 09
       (c) 2008 ICC Online Inform. Group

      Set  Items  Description
      ---  -----  -----------
?select brewing/de and cn=scotland not sl=na
             218  BREWING/DE
           50109  CN=SCOTLAND
          496934  SL=NA
      S1       6  BREWING/DE AND CN=SCOTLAND NOT SL=NA
?sort s1/all/sl,d
      S2       6  Sort S1/ALL/SL,D
?report s2/co,sl,em/all
 
Align paper;  press ENTER
?<enter>
           DIALOG(R)File 562 :ICC Brit.Co.Finan.Data
       (c) 2008 ICC Online Inform. Group All rts. reserv.
                                Total
                                Sales   Number of
Company Name                    (000s)  Employees
------------------------------  ------  ---------
 
BELHAVEN BREWERY GROUP PLC      29,622        232
BELHAVEN BREWERY COMPANY LIMIT  29,622        227
MACLAY GROUP PLC                17,037        219
MACLAY WHOLESALERS LIMITED      14,024         62
BROUGHTON ALES LIMITED             950         24
PORTGORDON MALTINGS LIMITED        262          7

(Using SORT in OneSearch) 

top