MIN
noun
say it: “MIN” /mɪn/
A SQL aggregate function that returns the lowest value in a column.
What is MIN in a relational database?
MIN — An aggregate function returning the lowest non-NULL value.
SELECT customer_id, MIN(total_amount) AS smallest_total
FROM purchase_order
GROUP BY customer_id;
In a sentence
- “MIN(OrderDate) shows each customer's first order.”
Level: Apprentice · More SQL terms at this level
Updated