Grouping and retrieving most recent entry in a table for each group
- by Lisa
First off, please bear with me if I don't state the SQL question correctly.
I have a table that has multiple columns of data.  The selection criteria for my table groups based on column 1(order #).  There could be multiple items on each order, but the item #'s are not grouped together.
Example:
Order   Customer    Order Date  Order Time  Item    Quantity  
123456  45  01/02/2010  08:00   140 4  
123456  45  01/02/2010  08:30   270 29  
123456  45  03/03/2010  09:00   140 6  
123456  45  04/02/2010  09:30   140 10  
123456  45  04/02/2010  10:00   270 35  
What I need is a result like:
Order   Customer    Order Date  Order Time  Item    Quantity  
123456  45  04/02/2010  09:30   140 10  
123456  45  04/02/2010  10:00   270 35  
This result shows that after all the changes the final order includes 10 of Item 140 and 35 of Item 270.
Is this possible.
python