I need to select only the data in the rows with the most recent date.
Sample data
ITEM DATE ESTIMATE
0010 20070320 100.00
0010 20070321 65.00
0010 20070322 80.00
0020 20070316 75.00
0020 20070318 20.00
0030 20070316 30.00
0040 20070316 40.00
Desired result:
0010 20070322 80.00
0020 20070318 20.00
0030 20070316 30.00
0040 20070316 40.00
Sample data
ITEM DATE ESTIMATE
0010 20070320 100.00
0010 20070321 65.00
0010 20070322 80.00
0020 20070316 75.00
0020 20070318 20.00
0030 20070316 30.00
0040 20070316 40.00
Desired result:
0010 20070322 80.00
0020 20070318 20.00
0030 20070316 30.00
0040 20070316 40.00