Skip to main content

Oracle Aggregate Functions

COUNT(*) : Returns the number of rows returned by the query.

MAX(expression) : Returns maximum value of expression.

MEDIAN(expression) : Returns the middle value or an interpolated value that would be the middle value once the values are sorted.

MIN(expression) : Returns minimum value of expression.

STDDEV(expression) : Returns the sample standard deviation of expression, a set of numbers.

SUM(expression) : Returns the sum of values of expression.

VARIANCE(expression) : Returns the variance of expression.


Popular posts from this blog