Re: a simple SELECT ?

From: Dante <dnotari_at_my-dejanews.com>
Date: Tue, 25 May 1999 10:38:11 GMT
Message-ID: <7iduij$jnp$1@nnrp1.deja.com>

It is simple

select *
  from (select *

        from mysales
       where id=1

    order by pdate desc)
where rownum <=10
/

In article <7i3t7f$jv6$1_at_xenon.inbe.net>,   "ACT_at_BLUEGATE" <act_at_bluegate.be> 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
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 25 1999 - 05:38:11 CDT