Returning a minimum or maximum value from a query

W

Wavequation

I have a query which returns 1 or more quantity values in one field for each
product, in numerically increasing order. Is there anyway I can only return
the minimum value for each product?
 
O

Ofer Cohen

Using a GroupBy query, like

SELECT TableName.Product, Min(TableName.Quantity) AS MinOfQuantity
FROM TableName
GROUP BY TableName.Product
 
Top