what do group by?? in sql

Kapil Singh Kumawat7y ago

Accepted answer

Group by is used to group the rows with same values.

For more info visit this URL -

https://www.w3schools.com/sql/sql_groupby.asp

Rajeev Kumar3y ago

GROUP BY: The GROUP BY clause is executed to group the data based on the values in one or more columns.

Priyanka Singh7y ago

The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. i.e if a particular column has same values in different rows then it will arrange these rows in a group.

Important Points:

GROUP BY clause is used with the SELECT statement.
In the query, GROUP BY clause is placed after the WHERE clause.
In the query, GROUP BY clause is placed before ORDER BY clause if used any.

Syntax:

SELECT column1, function_name(column2)
FROM table_name
WHERE condition
GROUP BY column1, column2
ORDER BY column1, column2;

function_name: Name of the function used for example, SUM() , AVG().

table_name: Name of the table.

condition: Condition used.

Nandha Kumar Nagarajan7y ago

tq so much