What is an aggregate query? Why would you add the same field multiple times to an aggregate query? ...

Salmams

wrote...

Posts: 693

Rep:

6 years ago

What is an aggregate query? Why would you add the same field multiple times to an aggregate query? ...

What is an aggregate query? Why would you add the same field multiple times to an aggregate query?

What will be an ideal response?

Read 66 times

1 Reply

Report

Related Topics

Solved A ________ query is used to display only aggregate data when the query is run.
Solved Multiple values returned from an SQL query that includes an aggregate function are called:
Solved Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword.
Solved Any criteria to a query containing an aggregate function must use the ________ keyword.
A(n) ________ query has an additional row which is used to display aggregate data.
A totals query allows you to see only the results of aggregate functions, not the detail. T/F?
Solved Which of the following is not a common aggregate function used in a crosstab query?
Which of the following is NOT true about using aggregate functions in a query?

Replies

chemistry9999

wrote...

6 years ago

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.

Report

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

1258 People Browsing

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

AJAX Chat © blueimp.net Integrated with SMF

Related Images

165

264

602

Your Opinion

Previous poll results: What's your favorite math subject?

The Toxic Skin and Fungi Defense

Strange Ingredients Lurking in Doritos Chips

It's sore throat season, why does my mucus have red spots?

Courses by Biology Forums

Bonobos, Chimpanzees, and the 98% DNA Link

Ready to ask a question on Biology Forums? Try it out

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.