Progress
SQL-92
Guide and Reference


MIN Function

Returns the minimum value in a group of values.

SYNTAX

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

EXAMPLE

This example illustrates the MIN function:

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

NOTES


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