Sunday, 9 October 2011

SQL- Aggregate Functions

Function
usage
AVG(expression)
Computes the average value of a column by the expression
COUNT(expression)
Counts the rows defined by the expression
MIN(expression)
Finds the minimum value In a column by the expression
MAX(expression)
Finds the maximum value in a column by the expression
SUM(expression)
Computes the sum of column values by the expression

No comments:

Post a Comment