My 2 Cents How To Use Aggregate Function In Dbms:

Swati Mishra

Content Writer
In the table summarize the values for columns by the Aggregate function.

These are the various aggregate functions.

AVG: return the average of values in a numeric expression

COUNT: return the number of values in an expression

MAX: return the highest value

MIN: return the minimum value

SUM: return the total of numeric values


Example:

SELECT ‘Average sales’=AVG (sales)
FROM employee
Above example returns the average value of all the sales in the employee table.

SELECT ‘sales’= COUNT(sales)
FROM employee
Above example return the total number of sales in employee table.
 
Top