Search code examples
db2max

What is the difference between max & greatest (min & least)?


Sql in db2 works with both max() function and greatest() function, but I was wondering if both are put there in the language, there must be a difference between the two?


Solution

  • Direct quote from the DB2 documentation:

    The GREATEST scalar function is a synonym for the MAX scalar function.