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

vicotolentino

  • Hero Member
  • *****
  • Posts: 552
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
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
 

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

For a complete list of videos, visit our video library