Returning a minimum or maximum value from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Using a GroupBy query, like

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