Progress
SQL-92
Guide and Reference


GREATEST Function

Returns the greatest value among the values of the given expressions.

SYNTAX

GREATEST ( expression , expression ... ) 

EXAMPLE

This example illustrates the GREATEST function:

SELECT cust_no, last_name, 
    GREATEST (ADD_MONTHS (start_date, 10), SYSDATE) 
    FROM customer ; 

NOTES

COMPATIBILITY

Progress Extension


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