« previous next »

Author Question: What is the purpose of the GROUP BY keyword? What will be an ideal ... (Read 52 times)

vicotolentino

  • Hero Member
  • *****
  • Posts: 552
on: Jul 7, 2018
What is the purpose of the GROUP BY keyword?
 
  What will be an ideal response?

Question 2

List the SQL aggregate functions.
 
  What will be an ideal response?


alexisweber49

  • Sr. Member
  • ****
  • Posts: 311
Reply #1 on: Jul 7, 2018
Answer to Question 1

The GROUP BY keyword is used in SQL queries in conjunction with the aggregate functions to enable summarizations across the groups of related data within tables.

Answer to Question 2

COUNT, SUM, AVG, MIN, and MAX.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

A Recently Discovered Member of the Local Group A Recently Discovered Member of the Local Group
A group of capped langurs. A group of capped langurs.
A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ... A funnel is one way to visualize the diagnostic process. The purpose is to narrow the possible ...
Group Study Group Study
In 1974 a UC Berkeley group fired an oxygen nucleus at a californium target. Giv In 1974 a UC Berkeley group fired an oxygen nucleus at a californium target. Giv
Deoxynucleotides (top) have an OH group at the position in the deoxyribose molecule Deoxynucleotides (top) have an OH group at the position in the deoxyribose molecule
Video: Introduction to Tuberculosis

For a complete list of videos, visit our video library