SQL Aggregate Functions

From Recital Documentation Wiki
Revision as of 14:42, 20 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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.