MAX
An aggregate function returning the highest non-NULL value.
What is MAX in a relational database?
MAX — An aggregate function returning the highest non-NULL value.
SELECT customer_id, MAX(total_amount) AS largest_total
FROM purchase_order
GROUP BY customer_id;
Level: Apprentice · More Database terms at this level
Updated