DATABASE & SQL/PLSQL

adplus-dvertising
Using Aggregate Functions
Previous Home Next

These function are specially executed for the mathematical expression.

Function NameParametersDescription
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