MIN (SQL Server Compact)

United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server Compact

SQL Server Compact 3.5 SP2

SQL Server Compact Technical Reference

SQL Reference (SQL Server Compact)

SQL Overview (SQL Server Compact)

+ (Add) (SQL Server Compact)

+ (Positive) (SQL Server Compact)

+ (String Concatenation) (SQL Server Compact)

- (Subtract) (SQL Server Compact)

- (Negative) (SQL Server Compact)

* (Multiply) (SQL Server Compact)

/ (Divide) (SQL Server Compact)

% (Modulo) (SQL Server Compact)

& (Bitwise AND) (SQL Server Compact)

| (Bitwise OR) (SQL Server Compact)

^ (Bitwise Exclusive OR) (SQL Server Compact)

~ (Bitwise NOT) (SQL Server Compact)

= (Equals) (SQL Server Compact)

> (Greater Than) (SQL Server Compact)

< (Less Than) (SQL Server Compact)

>= (Greater Than or Equal To) (SQL Server Compact)

<= (Less Than or Equal To) (SQL Server Compact)

<> (Not Equal To) (SQL Server Compact)

!= (Not Equal To) (SQL Server Compact)

!< (Not Less Than) (SQL Server Compact)

!> (Not Greater Than) (SQL Server Compact)

@@IDENTITY (SQL Server Compact)

@@DBTS (SQL Server Compact)

@@SHOWPLAN (SQL Server Compact)

ABS (SQL Server Compact)

ACOS (SQL Server Compact)

ALL (SQL Server Compact)

ALTER TABLE (SQL Server Compact)

AND (SQL Server Compact)

ASIN (SQL Server Compact)

ATAN (SQL Server Compact)

ATN2 (SQL Server Compact)

AVG (SQL Server Compact)

BETWEEN (SQL Server Compact)

CASE (SQL Server Compact)

CEILING (SQL Server Compact)

CHARINDEX (SQL Server Compact)

COALESCE (SQL Server Compact)

COLLATE (SQL Server Compact)

CAST and CONVERT (SQL Server Compact)

COS (SQL Server Compact)

COT (SQL Server Compact)

COUNT (SQL Server Compact)

CREATE DATABASE (SQL Server Compact)

CREATE INDEX (SQL Server Compact)

CREATE STATISTICS (SQL Server Compact)

CREATE TABLE (SQL Server Compact)

DATALENGTH (SQL Server Compact)

DATEADD (SQL Server Compact)

DATEDIFF (SQL Server Compact)

DATENAME (SQL Server Compact)

DATEPART (SQL Server Compact)

DDL Statements (SQL Server Compact)

DEGREES (SQL Server Compact)

DELETE (SQL Server Compact)

DML Statements (SQL Server Compact)

DROP INDEX (SQL Server Compact)

DROP STATISTICS (SQL Server Compact)

DROP TABLE (SQL Server Compact)

EXISTS (SQL Server Compact)

EXP (SQL Server Compact)

Expressions (SQL Server Compact)

FLOOR (SQL Server Compact)

FROM Clause (SQL Server Compact)

Functions (SQL Server Compact)

GETDATE (SQL Server Compact)

GROUP BY Clause (SQL Server Compact)

HAVING Clause (SQL Server Compact)

Hints (SQL Server Compact)

IDENTITY Property (SQL Server Compact)

IN (SQL Server Compact)

Information Schema (SQL Server Compact)

INSERT (SQL Server Compact)

IS [NOT] NULL (SQL Server Compact)

LEN (SQL Server Compact)

LIKE (SQL Server Compact)

LOG (SQL Server Compact)

LOG10 (SQL Server Compact)

LOWER (SQL Server Compact)

LTRIM (SQL Server Compact)

MAX (SQL Server Compact)

MIN (SQL Server Compact)

NCHAR (SQL Server Compact)

NEWID (SQL Server Compact)

NOT (SQL Server Compact)

Operators (SQL Server Compact)

OR (SQL Server Compact)

ORDER BY Clause (SQL Server Compact)

PATINDEX (SQL Server Compact)

PI (SQL Server Compact)

POWER (SQL Server Compact)

RADIANS (SQL Server Compact)

RAND (SQL Server Compact)

REPLACE (SQL Server Compact)

REPLICATE (SQL Server Compact)

Reserved Words (SQL Server Compact)

ROUND (SQL Server Compact)

RTRIM (SQL Server Compact)

SELECT Statement (SQL Server Compact)

SET IDENTITY INSERT (SQL Server Compact)

SET SHOWPLAN_XML (SQL Server Compact)

SET STATISTICS XML (SQL Server Compact)

SIGN (SQL Server Compact)

SIN (SQL Server Compact)

SOME | ANY (SQL Server Compact)

sp_show_statistics (SQL Server Compact)

sp_rename (SQL Server Compact)

SPACE (SQL Server Compact)

SQRT (SQL Server Compact)

STR (SQL Server Compact)

STUFF (SQL Server Compact)

SUBSTRING (SQL Server Compact)

SUM (SQL Server Compact)

TAN (SQL Server Compact)

timestamp (SQL Server Compact)

TOP (SQL Server Compact)

UNICODE (SQL Server Compact)

UNION (SQL Server Compact)

UPDATE (SQL Server Compact)

UPDATE STATISTICS (SQL Server Compact)

UPPER (SQL Server Compact)

USE (SQL Server Compact)

WHERE Clause (SQL Server Compact)

Minimize

This topic has not yet been rated - Rate this topic

SQL Server 2008 R2

Returns the minimum value in the expression.


MIN ([ ALL ] expression )

ALL: Applies the aggregate function to all values. ALL is the default.
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.

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

This is the result set:

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.