« previous next »

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

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Surface magnetic field of SU Aur (a young star of T Tauri type), reconstructed by means of Zeeman-Do Surface magnetic field of SU Aur (a young star of T Tauri type), reconstructed by means of Zeeman-Do
Polyps and polyposis. A polyp is a protruding growth from a mucous membrane lining a hollow organ. I Polyps and polyposis. A polyp is a protruding growth from a mucous membrane lining a hollow organ. I
Preparation of sterile field 5 Preparation of sterile field 5
Suicide rates in Canada are more than three times higher for males than for females Suicide rates in Canada are more than three times higher for males than for females
Draw the electric field of: •An electron and proton •Two electrons Draw the electric field of: •An electron and proton •Two electrons
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
Video: Hormonal regulation of pregnancy - week 1

For a complete list of videos, visit our video library