« previous next »

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

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

The term bacteria was devised in the 19th century by German biologist Ferdinand Cohn. He based it on the Greek word "bakterion" meaning a small rod or staff. Cohn is considered to be the father of modern bacteriology.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

Did you know?

More than one-third of adult Americans are obese. Diseases that kill the largest number of people annually, such as heart disease, cancer, diabetes, stroke, and hypertension, can be attributed to diet.

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
With tough economic times, a lot of people have lost their jobs—and their homes. If this happens, ... With tough economic times, a lot of people have lost their jobs—and their homes. If this happens, ...
Torque is a twisting force equal to the distance from the pivot point times the force applied ... Torque is a twisting force equal to the distance from the pivot point times the force applied ...
Symptoms of multiple sclerosis. Symptoms of multiple sclerosis.
Genomic and fossil evidence has been used to estimate the times of divergence of human and Neanderth Genomic and fossil evidence has been used to estimate the times of divergence of human and Neanderth
Video: Retina

For a complete list of videos, visit our video library