Export (0) Print
Expand All

Min

SQL Server 2000

Min

Returns the minimum value of a numeric expression evaluated over a set.

Syntax

Min(«Set»[, «Numeric Expression»])

Remarks

The Min function returns the minimum value of a numeric expression, specified in «Numeric Expression», evaluated over a set specified in «Set».

Example

If the respective values in the Sales measure for the USA, CANADA and MEXICO members are 1000, 2000, and 3000, the following example returns 1000:

Min({USA, CANADA, MEXICO}, Sales)
Show:
© 2014 Microsoft