I have to run a query where the chances of returning multiple rows for each individual item is very likely,
Item Price Date
0123456789 $4.00 1999-07-01-99
0123456789 $3.00 1999-05-01-99
What function could I use to return the most recent value of the item only?
0123456789 price 1999-07-01-99