Book Contents

Book Index

Next Topic

Home

MIN

MIN returns the smallest value of an expression over a group of rows. The return value is the same as the expression data type.

Syntax

MIN ( [ ALL | DISTINCT ] expression )

Semantics

 

ALL | DISTINCT

are meaningless in this context

expression

(any numeric, string, or date/time type) contains at least one column reference