Computer Science
What is the use of GROUP BY clause ?
SQL Joins & Grouping
3 Likes
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.
Answered By
2 Likes
Related Questions
Assertion. In order to carry out the join operation, there should be a governing condition.
Reason. A join condition may be based on equality, less than, greater than or non-equality.
What is the difference between HAVING and WHERE clause ?
What are aggregate functions? What is their use? Give some examples.
What type of functions can you use with GROUP BY and HAVING clauses ?