Grouping and Summarizing Data

Using Jet SQL Aggregates and Clauses to Group and Summarize Data
  • Susan Sales Harkins
  • Martin W. P. Reid

Abstract

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.

Keywords

Shipping Dick DMax Glean 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Susan Sales Harkins and Martin W.P. Reid 2002

Authors and Affiliations

  • Susan Sales Harkins
  • Martin W. P. Reid

There are no affiliations available

Personalised recommendations