« previous next »

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

joe

  • Hero Member
  • *****
  • Posts: 627
on: Aug 28, 2018
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
Reply #1 on: Aug 28, 2018
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
« previous next »
 

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Field horsetail Field horsetail
Wheat field versus lavender field Wheat field versus lavender field
A form letter is used when the same letter is sent to multiple recipients. A form letter is used when the same letter is sent to multiple recipients.
Multisystem effects of multiple sclerosis. Multisystem effects of multiple sclerosis.
An orange has four times the fiber of six ounces of orange juice An orange has four times the fiber of six ounces of orange juice
Guidelines for Field Triage of Injured Patients, Centers for Disease Control, 2011 Guidelines for Field Triage of Injured Patients, Centers for Disease Control, 2011
Video: Phases of the Female Reproductive Cycle - Hormonal regulation

For a complete list of videos, visit our video library