Re: A simple SELECT ?

Hi there,

    Take a look at the statement below and see if you like it...

SELECT CUSTOMER_ID , QUANTITY, DDATE
FROM DELIVERIES
WHERE DDATE >= SYSDATE -10
ORDER BY CUSTOMER_ID. Sherwin
SIEMENS "ACT_at_BLUEGATE" wrote:

> It seems simple...
>
> I've a deliveries table with three columns: date, customer id, and quantity.
>
> How can i retrieve in a query the last (in time) 10 deliveries for a
> specified customer ?
>
> Achille Carette, Bluegate
> act_at_bluegate.be
Received on Fri May 21 1999 - 10:26:59 CDT