Page 112 - Computer Software Application TP - Volume 1
P. 112

COMPUTER SOFTWARE APPLICATION - CITS


























           TASK 4 : Using GROUP BY:
           The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more
           column. It is generally used in a SELECT statement.

           SELECT product, SUM(amount) as total sales
           FROM sales
           GROUP BY product;
           This query selects the product and the total sales (SUM(amount)) for each product from the sales table, grouped
           by the product column.
           You can use other aggregate functions like COUNT, AVG, MIN, MAX, etc., depending on your requirements.
           1  SELECT product, COUNT(*) as total orders, AVG(amount) as avg sales
           FROM sales
           GROUP BY product;











































                                                           97
 CITS : IT & ITES - Computer Software Application - Exercise 29   CITS : IT & ITES - Computer Software Application - Exercise 29
   107   108   109   110   111   112   113   114   115   116   117