Summary and detail queries

This topic gives an example of a summary query and of a detail query based on this fictional grocery store data:

Product Category Product ID Product Quantity Cost
Dairy 10001 Cheese 3 9
Dairy 10002 Milk 2 6
Fruit 20001 Apple 8 12
Fruit 20003 Pineapple 5 4
Fruit 20004 Cherries 30 10
Bakery 30001 Sandwich loaf 10 20
Bakery 30001 Sandwich loaf 8 15
Bakery 30001 Sandwich loaf 2 6
Bakery 30001 Sandwich loaf 3 9
Bakery 30002 Toast loaf 20 25
Bakery 30002 Toast loaf 10 25
Bakery 30003 Wholemeal loaf 15 35
Bakery 30003 Wholemeal loaf 10 25
Bakery 30003 Wholemeal loaf 5 10
Bakery 30004 Cakes 6 12
Bakery 30004 Cakes 12 24

Summary query

A summary query provides a summarized listing. The result is a row which contains all output data items for each summary level. For example, a list of goods and quantities with IDs 30001 to 30003.

In this example:

  • The data filter item is Product ID =30001 to 30003
  • The output data items are Product and Quantity

This table shows the output:

Product Quantity
Sandwich loaf 23
Toast loaf 30
Wholemeal loaf 30
Total 83

Detail query

A detail query provides a detailed listing. The results is a row for each record in the database. For example, all products that include the term 'Loaf', and their quantities.

In this example:

  • The data filter item is Product =%Loaf%
  • The output data items are Product and Quantity
This table shows the output:
Product Quantity
Sandwich loaf 2
Sandwich loaf 3
Sandwich loaf 8
Sandwich loaf 10
Toast loaf 10
Toast loaf 20
Wholemeal loaf 5
Wholemeal loaf 10
Wholemeal loaf 15