Question

ip class 12 question... give proper and exact definition of GROUPBY clause

Answer 1

its GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results by one or more columns.

hope it helps

Answer 2

Group By clause is used for grouping the records of the database table(s).This clause creates a single row for each group and this process is called aggregation. To use group by clause we have to use at least one aggregate function in Select statement. We can use group by clause without where clause