🚀 go-pugleaf

Hello there,

Here's my scenario: We have three delivery trucks. On any given day, each 
truck can perform from one to four deliveries. Each delivery is numbered 
sequentially.

Here's a sample of our data in the DELIVERIES table:

TRUCK | DELIVERY | DATE | TIME
--------------------------------------------
1    1    03/31/2007    10:15            *
2    1    03/31/2007    10:25
2    2    03/31/2007    11:25            *
3    1    03/31/2007    10:30
3    2    03/31/2007    11:30
3    3    03/31/2007    12:30            *

To simplify things in this example: truck 1 did one delivery, truck 2 did 
two deliveries, and truck 3 did three deliveries.

I've put an asterisk next to the records I need to extract for any given 
day: I need one record per truck, the one with the last delivery for it. So, 
the result set should be:

TRUCK | DELIVERY | DATE | TIME
--------------------------------------------
1    1    03/31/2007    10:15            *
2    2    03/31/2007    11:25            *
3    3    03/31/2007    12:30            *

These are the records with the last delivery of each truck in any given day.

Note.- The last delivery record for each truck is determined by the 
sequential DELIVERY field. Date and time are just for reference.

TRUCK and DELIVERY are integer fields in the DELIVERIES table. Which SQL 
SELECT statement would give me the desired result set?

Thanks in advance,

-Jorge
Using IB6