MAX( )
Go Up to Statement and Function Reference (Language Reference Guide)
Retrieves the maximum value in a column. Available in gpre, DSQL, and isql.
MAX ([ALL] val | DISTINCT val)
| Argument | Description |
|---|---|
|
|
Searches all values in a column |
|
|
Eliminates duplicate values before finding the largest |
|
<val> |
A column, constant, host-language variable, expression, non-aggregate function, or UDF |
Description: MAX() is an aggregate function that returns the largest value in a specified column, excluding NULL values. If the number of qualifying rows is zero, MAX() returns a NULL value.
When MAX() is used on a CHAR, VARCHAR, or Blob text column, the largest value returned varies depending on the character set and collation in use for the column. A default character set can be specified for an entire database with the DEFAULT CHARACTER SET clause in CREATE DATABASE, or specified at the column level with the COLLATE clause in CREATE TABLE.
Example: The following embedded SQL statement demonstrates the use of SUM(), AVG(), MIN(), and MAX():
EXEC SQL
SELECT SUM (BUDGET), AVG (BUDGET), MIN (BUDGET), MAX (BUDGET)
FROM DEPARTMENT
WHERE HEAD_DEPT = :head_dept
INTO :tot_budget, :avg_budget, :min_budget, :max_budget;