Chapter 3 Building Physical Diagrams
You can use the query property sheet to modify the tables and columns used by the query.
You can also use it to add the following types of clauses to a query:
| SQL clause | Description |
|---|---|
| WHERE | Specify search conditions |
| GROUP BY | Divides rows into groups based on values in the columns |
| HAVING | Specify grouping conditions |
| ORDER BY | Sort query results by one or more columns |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |