a
 
SQLRef.Com 

            SqlRef.Com


SQL BASIC
DATA QUERY LANGUAGE
BASIC FUNCTION
AGGREGATE FUNCTION
DATA MANIPULATION LANGUAGE
DATA DEFINITION LANGUAGE
DATA CONTROL LANGUAGE
OTHERS

MIN()

SELECT MIN(<column>) FROM <table> [WHERE <conditions>]

MIN returns the minimum value from a group of value

Table: Orders
OrderID Customer Employee Order Date ShippedVia Freight ShipCountry
10248 Wilman Kala Buchanan, Steven 04-07-1996 Federal Shipping 32.38 France
10249 Hanari Carnes Peacock, Margaret 08-07-1996 United Package 65.83 Brazil
10250 Hanari Carnes Leverling, Janet 08-Jul-1996 United Package 58.17 Brazil
10251 Chop-suey Chinese Buchanan, Steven 11-Jul-1996 United Package 22.98 Switzerland
10252 Richter Supermarkt Dodsworth, Anne 12-Jul-1996 Federal Express 148.33 Switzerland

The following SQL statement returns 22.98 from Freight column.

SELECT MIN(Freight) FROM Orders

Resultset1
22.98
.



 
| Freebies | Free Trial | Add to Bookmark | Search | Link to Us |
Copyright © 2006 SqlRef.com. All rights reserved.