![]() SQL — Group BySyntaxGROUP BY column-commalist [HAVING expr] DescriptionThe BASIS SQL Engine supports the GROUP BY clause on SELECT statements. The GROUP BY clause provides the ability to group similar data so that a single result row reflects the accumulation of data from one or more physical rows. This also adds functionality to your SELECT statement and gives you more ability to manipulate aggregates. ExampleSelect AVG(sales_ly), sales_region from customer group by sales_region ______________________________________________________________________________________ Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks. |