Re: A simple SELECT ?

I should think this would work:

select *

	from Delivery
	where Customer_ID = <whatever> and rownum <= 10
	order by Delivery_Date desc;

"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 Wed May 26 1999 - 20:20:17 CDT