ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-28
Wild-Card Characters
The MAX function returns the largest value in the column, in the same data type as the
argument you supply.
If you specify DISTINCT, the MAX function calculates the result after excluding
duplicate and null values of the argument. If you do not specify DISTINCT, duplicate
values are retained; expression must contain at least one column-name and must
not contain any aggregate functions.
MIN
The MIN aggregate function has the following syntax:
The MIN function returns the smallest value in the column, in the same data type as
the argument you supply.
If you specify DISTINCT, the MIN function calculates the result after excluding
duplicate and null values of the argument. If you do not specify DISTINCT, duplicate
values are retained; expression must contain at least one column-name and must
not contain any aggregate functions.
SUM
The SUM aggregate function has the following syntax:
The SUM function returns a numeric value that is the sum of the values in the column.
If you specify DISTINCT, the SUM function calculates the result after excluding
duplicate values of the argument. If you do not specify DISTINCT, duplicate values are
retained; expression must contain at least one column-name and must not contain
any aggregate functions.
For more information, see the following documents:
Wild-Card Characters
Wild-card characters can be used in the LIKE clause operand, which is a quoted string,
to represent any character in a string. Table 3-7 summarizes NonStop ODBC Server
support of CORE SQL wild-card characters.
MIN ( { DISTINCT column-name } )
{ expression }
SUM ( { DISTINCT column-name } )
{ expression }
For Information About See
Aggregates in CORE SQL X/Open CAE Specification
Aggregates in NonStop SQL/MP NonStop SQL/MP Reference Manual