« previous next »

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

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

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
Field Garlic Field Garlic
EEG electrodes attached to the child’s scalp provide a record of brain activity in multiple ... EEG electrodes attached to the child’s scalp provide a record of brain activity in multiple ...
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 ...
. Calculate the net electric field at point B . Calculate the net electric field at point B
What is the contribution of studying wing spot in the field? What is the contribution of studying wing spot in the field?
Video: Egg and Sperm Formations in Animals Animation

For a complete list of videos, visit our video library