7.2. Group By clause

 

  • Whenever you use the aggregate function for display the value and also display other column with aggregate function that time you need to compulsory use group by cause.
  • The GROUP BY statement is often used with aggregate functions (COUNT, MAX, MIN, SUM, AVG) to group the result-set by one or more columns.

QUERY: - SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) ORDER BY column_name(s);

EXAMPLE: - SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country;

Last modified: Monday, 2 December 2019, 12:18 PM