Database Reference
In-Depth Information
Group Functions
A group function as the same states gets implemented on more
than one record within a column. They can be better understood
by looking at their real world examples. There are following five
very important group functions.
AVG
COUNT
MAX
MIN
SUM
Example:
SELECT AVG(sal) "Average"
FROM emp;
Output:
Average
----------
2077.21429
Using AVG function you can get the average of “sal” (salary)
column/field.
Example:
SELECT COUNT(*) "Total"
FROM emp;
Output:
Total
----------
18
Search WWH ::
Custom Search