WurzelGummidge
Technical User
If i have a purchase order table with many rows for the same product, how do i return the COST of a product based on the MAX of date_purchased - ie:
PRODUCT DATE_OF_PURCHASE COST
abc123 10-02-2003 21.20
abc123 25-05-2003 20.00
abc123 17-03-2003 22.60
abc123 02-08-2003 23.10
etc..
I would like to return the COST from the LAST purchased date
PRODUCT DATE_OF_PURCHASE COST
abc123 10-02-2003 21.20
abc123 25-05-2003 20.00
abc123 17-03-2003 22.60
abc123 02-08-2003 23.10
etc..
I would like to return the COST from the LAST purchased date