Kartier Pohs

Monday, June 15, 2015

GROUP FUNCTIONS in SQL

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:-

GROUP FUNCTIONS in SQL 
2-Command:- SUM

Purpose:- It returns the sum of all the  values for a column.
Example:-

GROUP FUNCTIONS in SQL 
3-Command:- AVG 

Purpose:- It returns the average of all the NOT NULL values
Example:-

GROUP FUNCTIONS in SQL 

4- Command:- MAX

Purpose:- It returns the largest value from the values of a given column.
Example:-

GROUP FUNCTIONS in SQL 

5- Command:- MIN
 

Purpose:- It returns the smallest value from the values of a given column.
Example:-
GROUP FUNCTIONS in SQL

No comments:

Post a Comment

Copyright 2015 @ Yogesh Prasad