Message-Id: <10742.126696@fatcity.com> From: Jacques Kilchoer Date: Mon, 15 Jan 2001 10:10:25 -0800 Subject: RE: Top-N records. This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07F1E.6F401130 Content-Type: text/plain; charset="windows-1252" > -----Original Message----- > From: Sachin Puri [mailto:sachin@siworldwide.com] > Sent: dimanche, 14. janvier 2001 20:00 > > Aldi > I just saw this topic today. I also saw comments of various > dbas regarding > your query but was > not impressed by anyone. I had answered saying exactly the same thing you did, and mentioned as a bonus a different way of doing the query (with an order by sub-select) for Oracle 8i. That wasn't enough to impress you? I'm going to go in a dark room now and hug myself and cry. ------_=_NextPart_001_01C07F1E.6F401130 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable RE: Top-N records.

> -----Original Message-----
> From: Sachin Puri [mailto:sachin@siworldwide.com= ]
> Sent: dimanche, 14. janvier 2001 20:00
>
> Aldi
> I just saw this topic today. I also saw  = comments of various
> dbas regarding
> your query but was
> not impressed by anyone.

I had answered saying exactly the same thing you did, = and mentioned as a bonus a different way of doing the query (with an = order by sub-select) for Oracle 8i.

That wasn't enough to impress you? I'm going to go in = a dark room now and hug myself and cry.