« previous next »

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

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

Carbamazepine can interfere with the results of home pregnancy tests. If you are taking carbamazepine, do not try to test for pregnancy at home.

Field experiment on effects of predation on male guppy colouration Field experiment on effects of predation on male guppy colouration
Olenoides erratus from the Mt. Stephen Trilobite Beds (Middle Cambrian) near Field, British Columbia Olenoides erratus from the Mt. Stephen Trilobite Beds (Middle Cambrian) near Field, British Columbia
Field Thistle Field Thistle
Macromolecules can have distinct binding sites for multiple ligands Macromolecules can have distinct binding sites for multiple ligands
The bacterium Escherichia coli is commonly referred to as E. coli. Seen here with multiple flagella The bacterium Escherichia coli is commonly referred to as E. coli. Seen here with multiple flagella
Aggregate Fruits: Strawberry Aggregate Fruits: Strawberry
Video: Double Stranded DNA Molecule Animation

For a complete list of videos, visit our video library