SQL Aggregate Functions
From Recital Documentation Wiki
Revision as of 14:42, 20 March 2009 by Yvonnemilne (Talk | contribs)
AGGREGATE FUNCTIONS
Class
SQL Applications
Purpose
Aggregate Functions
See Also
AVG(), COUNT(), MAX(), MIN(), SELECT, SUM()
Description
Aggregate Functions, also known as Group Functions, operate on a group of rows rather than individual rows. They return a single result row.
| Aggregate Function | Description |
|---|---|
| AVG() | The AVG() Aggregate Function returns the average value for the specified numeric column or expression. |
| COUNT() | The COUNT() Aggregate Function returns a row count. |
| MAX() | The MAX() Aggregate Function returns the maximum value for the specified numeric or date column or expression. |
| MIN() | The MIN() Aggregate Function returns the minimum value for the specified numeric or date column or expression. |
| SUM() | The SUM() Aggregate Function returns the sum of the specified numeric column or expression. |
