>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,