>I need help in selecting records from the following table (simplified):
>
>CUST_ID
>ORD_DATE
>ORD_TIME
>
>For a given date (ORD_DATE), I need to select one order record per customer (CUST_ID) based on the time of order (ORD_TIME). For example, the Order Time should be the latest of the day.
>
>I would appreciate any suggestions.
>
>Thank you.
Dmitry,
Not tested, but would this work?
SELECT Cust_ID, MAX(Ord_Time) ;
FROM MyTable ;
WHERE Ord_Date = ?vp_OrdDate ;
GROUP BY Cust_ID
HTH,
Jim