What is the purpose of the GROUP BY keyword? What will be an ideal ...

Author Question: What is the purpose of the GROUP BY keyword? What will be an ideal ... (Read 13 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.

Need homework help now?

Ask unlimited questions for free

Ask a Question

« previous next »

Did you know?

Walt Disney helped combat malaria by making an animated film in 1943 called The Winged Scourge. This short film starred the seven dwarfs and taught children that mosquitos transmit malaria, which is a very bad disease. It advocated the killing of mosquitos to stop the disease.

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Most women experience menopause in their 50s. However, in 1994, an Italian woman gave birth to a baby boy when she was 61 years old.