Difference between revisions of "SQL Aggregate Functions"

Revision as of 11:39, 21 January 2013 (view source) Helen.george (Talk | contribs) ← Older edit		Revision as of 11:05, 30 January 2013 (view source) Helen.george (Talk | contribs) Newer edit →
Line 9:		Line 9:
−	{| class="wikitable" width=100%	+	{| class="wikitable" width="100%"
	!Aggregate Function||Description		!Aggregate Function||Description
	|-		|-

---

Revision as of 11:05, 30 January 2013

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.

valign="top"|MIN()||The MIN() Aggregate Function returns the minimum value for the specified numeric or date column or expression.

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.
SUM()	The SUM() Aggregate Function returns the sum of the specified numeric column or expression.