« previous next »

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

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

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

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

Visual Field Defects Visual Field Defects
The reflection nebula NGC 1999 is brilliantly illuminated by V380 Orionis (center), a variable star The reflection nebula NGC 1999 is brilliantly illuminated by V380 Orionis (center), a variable star
Generally, the total tax burden in the United States is much lower than that of other industrialize Generally, the total tax burden in the United States is much lower than that of other industrialize
This lithograph of the New York draft riots, 1863, shows that although the rioters mainly targeted b This lithograph of the New York draft riots, 1863, shows that although the rioters mainly targeted b
Food Digestion Times Food Digestion Times
Aggregate Fruits: Strawberry Aggregate Fruits: Strawberry
Video: Neural regulation of blood pressure - baroreceptor and chemoreceptor reflexes

For a complete list of videos, visit our video library