« previous next »

Author Question: What is an aggregate query? Why would you add the same field multiple times to an aggregate query? ... (Read 66 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?

Interferon was scarce and expensive until 1980, when the interferon gene was inserted into bacteria using recombinant DNA technology, allowing for mass cultivation and purification from bacterial cultures.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

To combat osteoporosis, changes in lifestyle and diet are recommended. At-risk patients should include 1,200 to 1,500 mg of calcium daily either via dietary means or with supplements.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Fallow deer in field Fallow deer in field
Preparation of sterile field 3 Preparation of sterile field 3
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.
Drugs Used to Treat Multiple Sclerosis Drugs Used to Treat Multiple Sclerosis
Preterm birth rates, by single and multiple births, Canada Preterm birth rates, by single and multiple births, Canada
A test field of GM papaya A test field of GM papaya
Video: Anaphylaxis Animation

For a complete list of videos, visit our video library