Progress
SQL-92
Guide and Reference
COUNT Function
Computes either the number of rows in a group of rows or the number of non-null values in a group of values.
SYNTAX
EXAMPLE
This example illustrates the COUNT function:
NOTES
- The keyword DISTINCT specifies that the duplicate values are to be eliminated before computing the count.
- If the argument to COUNT function is ’*’, then the function computes the count of the number of rows in a group.
- If the argument to COUNT function is not ’*’, then null values are eliminated before the number of rows is computed.
- The argument column_ref or expression can be of any type.
- The result of the function is of integer type. The result is never null.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |