Group By

Syntax

GROUP BY column-commalist [HAVING expr]

Description

The 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 provides more ability to manipulate aggregates.

Example

Select AVG(sales_ly), sales_region from customer group by sales_region