Chapter 3 Building Physical Diagrams

Query property sheet Having tab

This tab lists the expressions in the HAVING clause, which restrict the data returned by a query with a GROUP BY clause.

You can add or delete expressions as appropriate, and reorder the expressions in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

Steps To add an expression:

  1. Click in the first empty row in the list.
  2. [optional] Enter a prefix in the Prefix column.
  3. In the first Expression column, select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  4. In the Operator column, select an operator from the list.
  5. In the second Expression column, select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  6. [optional] Enter a suffix in the Suffix column.

 

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