Question

what is group function in my sql?

Answer 1

The GROUP BY clause is a SQL command that is used to group rows that have the same values.

 The GROUP BY clause is used in the SELECT statement .Optionally it is used in conjunction with aggregate functions to produce summary reports from the database.

That's what it does, summarizing datafrom the database.

The queries that contain the GROUP BY clause are called grouped queries and only return a single row for every grouped item.


this is ur answer...☺️

 

Answer 2

Hey, mate here is your answer》》

Introduction to MySQL GROUP BY clause. The GROUP BY clause groups a set of rows into a set of summary rows by values of columns or expressions. ... In other words, it reduces the number of rows in the result set. You often use the GROUP BY clause with aggregate functions such as SUM , AVG , MAX , MIN , and COUNT.

Hope this answer will help you..《《