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