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

In other subjects