Chapter 3 Building Physical Diagrams

Inserting a GROUP BY clause in a query

To insert a GROUP BY clause in a query:

1. From the Query property sheet, click the Group By tab.
   
   The Group By page appears.
2. Click the Add a Row tool.
   
   Click the new line in the list.
   
   or
   
   Click a new line in the list.
   
   A down arrowhead appears at the end of the line.
3. Click the down arrowhead.
   
   A dropdown list appears. It lists all the available columns in the tables defined for the view.
4. Select a column.
   
   The Column name appears in the list.
   
   
      Customizing an expression
   You can customize a column expression by clicking the Ellipsis button next to the down arrowhead. An SQL Editor appears. Type an expression in the textbox and click OK. The new expression appears in the column list.
   
   
5. Click OK.
   
   The selected columns appear in a GROUP BY clause in the textbox containing the SQL statement in the SQL Query page.

Copyright (C) 2005. Sybase Inc. All rights reserved.