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

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.