Use the Group By page to create a Group By clause in your SQL query. When transferring summary records, the Group By clause lets you separate records from the AS/400 files into more than one group.