Export (0) Print
Expand All

MIN Function

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the smallest numeric value in a column. Ignores logical values and text.





The column in which you want to find the smallest numeric value.

A decimal number.

The MIN function takes a column as an argument, and returns the smallest numeric value in the column. The following types of values in the columns are counted:

  • Numbers

  • Dates

  • If the column contains no numerical data, MIN returns blanks.

Empty cells, logical values, and text are ignored. If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.

The following example returns the smallest value from the calculated column, ResellerMargin.


The following example returns the smallest value from a column that contains dates and times, TransactionDate. This formula therefore returns the date that is earliest.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft