Find data associated with most recent record 1

[mbrichmo]

I would like to know how to get the data associated with the most recent record for each value of a given field i.e.:

Orders(OrderID, OrderDate, Customer, Item)

Find the most recent order for each customer and return the item for that order.

Thanks!

 

[PWise]

Select orders.*
from orders
inner join (Select Customer, Max(OrderDate) MaxOrderDate
from orders
Group by Customer )MaxOrder
on maxorder.Customer=orders.Customer
and maxorderMaxOrderDate=orders.OrderDate