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

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.