Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Aggregate Expressions
MAX FunctionThe MAX function returns the largest value in the specified column or expression.

MAX Function

The MAX function returns the largest value in the specified column or expression.

Using the DISTINCT keyword does not change the results. The query in the following example finds the most expensive item that is in stock but has not been ordered:

SELECT MAX(unit_price) FROM stock
   WHERE NOT EXISTS (SELECT * FROM items 
      WHERE stock.stock_num = items.stock_num AND
      stock.manu_code = items.manu_code);

NULLs are ignored unless every value in the column is NULL. If every column value is NULL, the MAX function returns a NULL for that column.