Using Aggregate Functions
| Previous | Home | Next |
These function are specially executed for the mathematical expression.
| Function Name | Parameters | Description |
| AVG | (ALL, DISTINCT Expression) | Return the average of value in a numeric expression |
| COUNT | (*) | Returns the no. of rows returned by the query |
| MAX | (expression) | Return the highest value in the expression |
| MIN | (expression) | Return the lowest value in the expression |
| SUM | (ALL, DISTINCT Expression) | Return the total of value in a numeric expression |
The AVG, COUNT, MAX, MIN and SUM function ignore NULL values, whereas the COUNT (*) function counts the NULL values.
Examples:
SELECT 'avg'=AVG (discount) FROM discounts
Description: Returns the average value of the discount.
Eamples:
SELECT 'sum'=SUM (discount) FROM discounts
Description: Returns the sum value of the discount.
Eamples:
SELECT 'sum'=SUM (discount) FROM discounts
Description: Returns the sum value of the discount
Eamples:
SELECT 'sum'=SUM (discount) FROM discounts
Description: Returns the minimum value of the discount in discounts table.
Eamples:
SELECT 'sum'=SUM (discount) FROM discounts
Description: Returns the sum value of the discount.
Eamples:
SELECT 'max'=MAX (discount) FROM discounts
Description: Returns the maximum value of the discount in discounts table.
Eamples:
SELECT 'count'=COUNT (discount) FROM discounts
Description: Return the number of discount value in discounts table.
| Previous | Home | Next |