• ⌂ Aggregate
• Functions
  • AVG()
  • COUNT()
  • GROUP_CONCAT()
  • MAX()
  • MIN()
  • SUM()

MAX()

Return the maximum value resulting from an expression across all aggregated rows.

Prototype

mixed MAX(expression expression)

Parameters

• expression - Optional expression, such as a dot-notation field evaluate for each row.

Return

Maximum value resulting from an expression across all aggregated rows.

Example

SELECT OID, Date, MAX(LineItems.Amount) AS MaxAmount FROM Invoice

Related

MIN()

• < GROUP_CONCAT()
• MIN() >