Progress
SQL-92
Guide and Reference


MAX Function

Returns the maximum value in a group of values.

SYNTAX

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

EXAMPLE

This example illustrates the MAX function:

SELECT order_date, product, MAX (qty)
     FROM orders
     GROUP BY order_date, product ; 

NOTES


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