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

COUNT ( { [ ALL ] expression } | { DISTINCT column_ref } | * ) 

EXAMPLE

This example illustrates the COUNT function:

SELECT COUNT (*)
     FROM orders
     WHERE order_date = SYSDATE ; 

NOTES


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