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

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Famous people who died from poisoning or drug overdose include, Adolf Hitler, Socrates, Juan Ponce de Leon, Marilyn Monroe, Judy Garland, and John Belushi.

Did you know?

Anesthesia awareness is a potentially disturbing adverse effect wherein patients who have been paralyzed with muscle relaxants may awaken. They may be aware of their surroundings but unable to communicate or move. Neurologic monitoring equipment that helps to more closely check the patient's anesthesia stages is now available to avoid the occurrence of anesthesia awareness.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.