The MAX function returns the largest value in the specified column or expression. The following SQL statement determines the project with the latest end date:

SELECT MAX(ACENDATE)
FROM DSN81010.PROJACT;

The result of the MAX function is of the same data type as the column or expression on which it operates.

The argument of the MAX function can be of any built-in data type other than CLOB, DBCLOB, BLOB, ROWID, or XML.

5 Top+features + of+ MongoDb (1 of 5)

Character string arguments can be no longer 255 bytes and graphic string arguments can be no longer than 127 bytes.
Best example for MAX salary:

SELECT MAX(SALARY)
FROM DSN81010.EMP
WHERE WORKDEPT = ‘D21’
AND SEX = ‘M’;

Advertisements