>SELECT item,MIN(exp) FROM test GROUP BY item >SELECT item,MAX(exp) FROM test GROUP BY item >SELECT item,exp FROM test GROUP BY item,exp >SELECT item,exp FROM test GROUP BY exp,item > >set engine 70 >SELECT item,exp FROM test GROUP BY item >>
SELECT Customer.CustomerID, CompanyName, MAX(OrderDate) ; FROM Customer ; JOIN Order ; ON Customer.CustomerID = Order.CustomerID ; GROUP BY CustomerIDIn this case, of course, either solution--adding the field to the GROUP BY or wrapping it with MAX()--works.