What is MAX in DB2? Is it possible to use MAX in a CHAR column?

1.	What is MAX in DB2? Is it possible to use MAX in a CHAR column?
Answer» MAX() is an aggregate function that returns the maximum value from a set of values. For example, if we have a database of MOVIES, we can apply MAX(rating) on the rating ATTRIBUTE and it will SELECT the ROWS in which we have the movies with the highest ratings. Yes, MAX can be used on a CHAR column.

Discussion