Grouping and Summarizing Data
Using Jet SQL Aggregates and Clauses to Group and Summarize Data
If you work with databases on a regular basis, you’ll probably often run into the term aggregate. In regards to databases, an aggregate is simply a set or group of records. Hence, to aggregate data means to group or summarize it. You can use Jet SQL to aggregate in one of two ways:
by grouping data using a GROUP BY clause, or
by summarizing data using SQL aggregate functions.
KeywordsSelect Statement Order Group Aggregate Function Column Heading Order Date
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Unable to display preview. Download preview PDF.
© Susan Sales Harkins and Martin W.P. Reid 2002