min

Return the minimum value in each aggregate

Syntax

MIN(value_expr)

Arguments

expression

The expression for which the minimum value is to be returned.

Description                             

This function returns the minimum value of expression over all the rows of each aggregate.

Example

open nsfawards;

select orgid, min(amount), max(amount) from nsforg natural join award
    where amount > 1 
    group by 1 having count(*) > 5000;

orgid       min(amount)       max(amount)
CHE                2200          24999479
DMI                1686          10870000
DMR                2000          87716900
DMS                 200          17750000
DUE                 961          13217804
EAR                 235          84999999
IBN                  91          11914983
INT                 285          30420573
OCE                 473         300937389
SES                  76          14797014