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

MIN()

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

Prototype

mixed MIN(expression expression)

Parameters

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

Return

Minimum value resulting from an expression across all aggregated rows.

Example

SELECT OID, Date, MIN(LineItems.Amount) AS MinAmount FROM Invoice

Related

MAX()

• < MAX()
• SUM() >