Progress
SQL-92
Guide and Reference


AVG Function

Computes the average of a collection of values. The keyword DISTINCT specifies that the duplicate values are to be eliminated before computing the average.

SYNTAX

AVG ( { [ ALL ] expression } | { DISTINCT column_ref } ) 

EXAMPLE

This example illustrates the AVG function:

SELECT AVG (salary)
     FROM employee
     WHERE deptno = 20 ; 

NOTES


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095