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

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

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?

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.

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?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.