Re: a simple SELECT ?

From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Fri, 21 May 1999 15:26:09 -0600
Message-ID: <7i4iso$crk$1@bgtnsc03.worldnet.att.net>

You didn't mention the language/interface you want to do this in.

Let's assume Pro*C, PL/SQL, or OCI, and you can look for the same capability in your environment.

Define a cursor to the rows you want ordered by date (ascending or descending), and write a loop to fetch up to ten records.

--

---

Richard Armstrong
State Of The Art Consulting, Inc.
http://www.stateoart.com

---

ACT_at_BLUEGATE <act_at_bluegate.be> wrote in message news:7i3t7f$jv6$1_at_xenon.inbe.net...
> 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 - 16:26:09 CDT