MIN
An aggregate function returning the lowest non-NULL value.
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;
Level: Apprentice · More Database terms at this level
Updated