Author Question: What is an aggregate query? Why would you add the same field multiple times to an aggregate query? ... (Read 56 times)

joe

  • Hero Member
  • *****
  • Posts: 627
What is an aggregate query? Why would you add the same field multiple times to an aggregate query?
 
  What will be an ideal response?

Question 2

You must always display footers in all slides in a presentation
 
  Indicate whether the statement is true or false



patma1981

  • Sr. Member
  • ****
  • Posts: 292
Answer to Question 1

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.

Answer to Question 2

FALSE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Approximately one in three babies in the United States is now delivered by cesarean section. The number of cesarean sections in the United States has risen 46% since 1996.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

For a complete list of videos, visit our video library