ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-33
Wild-Card Characters
MAX returns a floating-point value for INT expressions. For other types of expressions,
the value returned depends on the value of the expression being evaluated.
MIN
The MIN aggregate function has the following syntax:
MIN returns the minimum value in the column identified by expression. MIN can be
used with numeric, character, and date columns, but not with bit columns. With
character columns MIN returns the value that is lowest in the collating sequence. MIN
ignores null values.
MIN returns a floating-point value for INT expressions. For other types of expressions,
the value returned depends on the value of the expression being evaluated.
SUM
The SUM aggregate function has the following syntax:
SUM returns a floating-point value that represents the sum of all values in the column
identified by expression. If you include DISTINCT, SUM eliminates duplicate values
before adding the values. SUM ignores null values. SUM can be used with numeric
columns only.
If you include DISTINCT when using the NonStop ODBC Server, the expression
cannot be a constant. (The expression can be a constant when using
Transact-SQL.)
For more information, see the following documents:
Wild-Card Characters
Wild-card characters are used with the LIKE operator to represent any character in a
string. Table 4-12 summarizes NonStop ODBC Server support of Transact-SQL wild-
card characters.
MIN ( expression )
SUM ( [ DISTINCT ] expression )
For Information On See
Aggregates in Transact-SQL Microsoft SQL Server Transact-SQL Reference
Aggregates in NonStop SQL/MP NonStop SQL/MP Reference Manual