Aggregate Functions

NameDescription
AVGCalculates the average
COUNT(x)Returns the number of rows returned by a query involving x
MAXReturns the maximum value
MEDIANReturns the median value
MINReturns the minimum value
STDDEVReturns the standard deviation
SUMReturns the sum
VARIANCEReturns the variance

Incorrect Usage of Aggregate Functions

Home »
Oracle » 
Aggregate_Functions