What is an aggregate query? Why would you add the same field multiple times to an aggregate query?
What will be an ideal response?
An aggregate query performs arithmetic summary functions on the query including sum, average, count, minimum, and maximum. Each column calculates just one aggregate function so if you want to show more than one, you would add the same field multiple times. For example to get all five summary functions of the same field, you would add the field to the query five times.
You might also like to view...
Which of the following is a feature of Live bookmarks?
A) Adds RSS technology to bookmarks B) Streams live television programs C) Broadcasts webinars D) Enables you to pin your favorite website images
Insert a column ________ to manually align columns in a more even fashion; for example, forcing a column to start at the top of a page
Fill in the blank(s) with correct word