GROUP BYย clause in SQL statements is used to group the result-set by one or more columns that have the same values. It is often used with aggregate functions like SUM, AVG, MIN, MAX & COUNT. GROUP BY clause is placed after WHERE clause.
Syntax of GROUP BY clause in SQL-
SELECTย <column_name(s)>
FROMย <table_name>
WHERE<condition>
GROUP BY<column_name(s)>;
Example of GROUP BY clause in SQL-
SELECT COUNTย (CustomerID), Country
FROMย Customers
GROUP BYย Country;
โThis SQL statement will list the number of customers in each country.
Saraswat World Changed status to publish June 8, 2023
Write your answer.
Leave a Reply