Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 57 of 91

Relational Database and SQL — Question 18

Back to all questions
18
Question

Question 15

What is the significance of GROUP BY clause in an SQL query?

Answer

The GROUP BY clause in SQL can be used in a SELECT statement to collect data across multiple records and group the results by one or more columns. It groups the rows on the basis of the values present in one of the columns and then the aggregate functions are applied on any column of these groups to obtain the result of the query.