MAX
Examples
SELECT
dept_no,
MAX(salary)
FROM employee
GROUP BY dept_no
MAX
ExamplesSELECT
dept_no,
MAX(salary)
FROM employee
GROUP BY dept_no
MIN()
Minimum
Returns a result of the same data type the input expression.
MIN ([ALL | DISTINCT] <expr>)
Parameter | Description |
---|---|
expr |
Expression.It may contain a table column, a constant, a variable, an expression, a non-aggregate function or a UDF.Aggregate functions are not allowed as expressions. |
MIN
returns the minimum non-NULL
element in the result set.
If the group is empty or contains only NULL
s, the result is NULL
.
If the input argument is a string, the function will return the value that will be sorted first if COLLATE
is used.
This function fully supports text BLOB
s of any size and character set.
Note
|
The |