|
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
.
|
|