MIN
The function MIN returns the minimum value of items in a group. Without a GROUP BY clause it will aggregate with all rows of the SELECT.
| SQL Syntax: |
MIN( expression ) | |
| Parameters: |
expression
|
|
| Return Type: |
the same as the expression. |
Examples:
SELECT MIN( price ) FROM mytableSELECT MIN( price ) FROM mytableSELECT MIN( price ) FROM mytable t GROUP BY t.name
see also:
MAX
SQL Aggregate Functions