0 out of 1 rated this helpful - Rate this topic

MIN (SQL Server Compact Edition)

SQL Server 2005

Returns the minimum value in the expression.

Copy


MIN ( [ ALL ] expression )

expression: A constant, column name, or function, and any combination of arithmetic, bitwise, and string operators. MIN can be used with numeric, nchar, nvarchar, or datetime columns but not with bit columns. Aggregate functions and subqueries are not permitted.

Returns a value of the same type as expression.

MIN ignores any null values.

With character data columns, MIN finds the value that is lowest in the sort sequence.

The following example uses MIN to determine the lowest priced item in the Products table.

Copy

SELECT MIN(UnitPrice) AS "Least Expensive" FROM Products

This is the result set:

Copy

Least Expensive
---------------
2.5

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ