How to use Group by clause in wrkqry

[nirmal_ec]

How to use Group by clause in wrkqry

[DeadManWalks]

Re: How to use Group by clause in wrkqry

No "group by " in wrkqry.

But you can

1)

Opt    Query Definition Option     
     > Specify file selections     
       Define result fields        
     > Select and sequence fields  
     > Select records              
 1   > Select sort fields 

                              Select Sort Fields     
                                                     
Type sort priority (0-999) and A (Ascending) or D (De
  the names of up to 32 fields, press Enter.         
                                                     
Sort                                                 
Prty A/D  Field           Text                       
  10  A   T01.HBRKREF     BRK REF# 

Opt    Query Definition Option           
     > Specify file selections           
       Define result fields              
     > Select and sequence fields        
     > Select records                    
     > Select sort fields                
       Select collating sequence         
       Specify report column formatting  
 1   > Select report summary functions 

                       Select Report Summary Functions  
                                                        
Type options, press Enter.                              
  1=Total   2=Average   3=Minimum   4=Maximum   5=Count 
                                                        
---Options---  Field           Text                     
            5  T01.HBRKREF     BRK REF# 

1   > Define report breaks 

                             Define Report Breaks   
                                                    
Type break level (1-6) for up to 9 field names, pres
  (Use as many fields as needed for each break level
                                                    
Break    Sort                                       
Level    Prty  Field           Text                 
  1        10  T01.HBRKREF     BRK REF#