SQL GROUP BY and HAVING Clause: Explained with Example

The "GROUP BY" statement is used in SQL to group rows based on one or more columns. It is often used in conjunction with aggregate functions, such as SUM, COUNT, AVG, etc., to perform calculations on each group.\n\nThe "HAVING" clause is used along with the "GROUP BY" statement to filter the grouped rows based on a specified condition. It is similar to the "WHERE" clause, but it operates on grouped rows rather than individual rows.\n\nHere is an example of how "GROUP BY" and "HAVING" can be used together:\n\nSuppose we have a table called "Orders" with columns "Product" and "Quantity". We want to find the total quantity for each product and display only the products with a total quantity greater than 100.\n\n\nSELECT Product, SUM(Quantity) as TotalQuantity\nFROM Orders\nGROUP BY Product\nHAVING SUM(Quantity) > 100;\n\n\nIn this example, the "GROUP BY" statement groups the rows by the "Product" column. The "SUM(Quantity)" calculates the total quantity for each product. The "HAVING" clause filters the grouped rows and only selects the products with a total quantity greater than 100.