CBSE Class 12 Computer Science Question 61 of 91

Grouping Records, Joins in SQL — Question 2

Back to all questions
2
Question

Question 2

What is the use of GROUP BY clause ?

Answer

The GROUP BY clause in SQL is used to combine all records that have identical values in a particular field or group of fields. This grouping results in one summary record per group if group functions, such as aggregate functions, are used with it.