MAX
Given an input set of values, MAX returns the maximum value in that set.
Syntax
MAX (expression)
Remarks
| • | Expression can be numeric, string, or date-time. |
| • | The output type is the same as the input type. |
| • | If the input is a CHAR, the output is the highest string in the sorting order. |
| • | If the input is date/time, the output is the latest date/time. |
| • | If the input is a literal, the output is the same literal. |
| • | If the input is a numeric expression, MAX compares the values in algebraic order; that is, large negative numbers are less than small negative numbers, which are less than zero. |
The following table lists the input types that you can use in MAX, and their corresponding output types.
|
Data Type of expression |
Output Type |
|
BIGINT, CHAR, DATE, DECIMAL, DOUBLE, FLOAT, INTEGER, INTERVAL_DAY, INTERVAL_YEAR, LONGVARCHAR, NULL, NUMERIC, REAL, SMALLINT, TIME, TIMESTAMP, TINYINT, VARCHAR |
Same type as the input type. For example, if the input is of type CHAR, the output is also of type CHAR. |
Example
SELECT MAX (products.UnitPrice) Price,
MAX (orders.OrderDate) Date
FROM /shared/examples/ds_inventory/products products,
/shared/examples/ds_orders/orders orders