GROUP FUNCTIONS
The Group/Aggregate functions available in ORACLE are described below.
1- Command:- COUNT
Purpose:- It returns the total number of NOT NULL values in a set of records or number of rows.
Example:-
2-Command:- SUM
Purpose:- It returns the sum of all the values for a column.
Example:-
3-Command:- AVG
Purpose:- It returns the average of all the NOT NULL values
Example:-
4- Command:- MAX
Purpose:- It returns the largest value from the values of a given column.
Example:-
5- Command:- MIN
Purpose:- It returns the smallest value from the values of a given column.
Example:-
0 comments:
Post a Comment