Hi, the title is probaby not very clear, example below
ID, Name, Price, CreateDate
1, Apple, $10, 11-10-2009 11:00AM
2, Apple, $12, 11-10-2009 11:30AM
3, Orange, $15, 11-9-2009 1:00PM
I would like to construct a query that returns the rows (all columns) with the most up to date price by itemName (row 2 and row 3).
How would i do that? Please Help!