Visual Database Tools
Querying on Groups of Rows
You can create a query result in which each result row corresponds to an entire group of rows from the original data. To learn about the logical principles for creating such queries, see Collapsing Groups of Rows.
To learn the details about creating such queries, see the topics listed in the following table:
| To | See |
|---|---|
| Learn about excluding duplicate rows | Excluding Duplicate Rows |
| Create subsets of summary information by organizing data into groups | Grouping Rows in Query Results |
| Count the number of rows that meet specific conditions | Counting Rows in a Table |
| Create an average, sum, or other summary from information in all rows in a table | Summarizing Values for All Rows in a Table |
| Use calculations to create summary information | Summarizing Values Using Custom Expressions |
| Create search conditions that apply to groups of rows | Specifying Conditions for Groups |
| Use search conditions on both individual rows and on groups of rows | Using HAVING and WHERE Clauses in the Same Query |