« previous next »

Author Question: What is an aggregate query? Why would you add the same field multiple times to an aggregate query? ... (Read 28 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 average adult has about 21 square feet of skin.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Multiple crossovers can include more than two chromatids Multiple crossovers can include more than two chromatids
A Snapshot of the Sun’s Global Magnetic Field A Snapshot of the Sun’s Global Magnetic Field
Chemistry for Changing Times Chemistry for Changing Times
. Calculate the net electric field at point B . Calculate the net electric field at point B
Multiple choice bio Multiple choice bio
Video: Ciliate conjugation Animation

For a complete list of videos, visit our video library