« previous next »

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

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Multisystem effects of multiple sclerosis. Multisystem effects of multiple sclerosis.
Optical microscopes are commonly configured for bright-field (transmitted), phas Optical microscopes are commonly configured for bright-field (transmitted), phas
Multisystem effects of multiple sclerosis. Multisystem effects of multiple sclerosis.
For Gulf War veterans, lack of social support in the field is related to postwar depression. The ... For Gulf War veterans, lack of social support in the field is related to postwar depression. The ...
Press with (A) fingertips into GB-30; or (B) with thumb into GB-30; press 2–3 times. Press with (A) fingertips into GB-30; or (B) with thumb into GB-30; press 2–3 times.
Estimated times of divergence of human and Neanderthal genomic Estimated times of divergence of human and Neanderthal genomic
Video: Role of ATP in muscle movement

For a complete list of videos, visit our video library