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 47 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?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

One way to reduce acid reflux is to lose two or three pounds. Most people lose weight in the belly area first when they increase exercise, meaning that heartburn can be reduced quickly by this method.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.