Re: Top N without inline

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 23 Jun 2010 17:55:52 +0100
Message-ID: <AANLkTilzJk0Nf2QvAOFaMAzUt0F1Ama99luNbexp-8Yx_at_mail.gmail.com>

Or common table expressions in the std. It may well be worth searching for that I'm the tool docs, since a tool that doesn't accept subqueries is unlikely to accept a CTE

Niall Litchfield

On Jun 23, 2010 5:49 PM, "Stefan Knecht" <knecht.stefan_at_gmail.com> wrote:

You're welcome.

It's called subquery factoring, and it's hidden somewhere in the depths of the 100's of pages the SELECT reference for Oracle spans :-)

Good luck

Stefan

• Stefan P Knecht CEO & Founder s_at_10046.ch 10046 Consulting GmbH Schwarzac... On Wed, Jun 23, 2010 at 6:27 PM, Dave Pacia <davepacia_at_yahoo.com> wrote:

> Thanks Stefan. That is syntax I had not seen before--didn't know you could
> do that. I've given it to the developer - let's see what he says.
>
> Dave Pacia
>
> ------------------------------
> *From:* Stefan Knecht <knecht.stefan_at_gmail.com>
> *To:* davepacia_at_yahoo.com
> *Sent:* Wed, June 23, 2010 12:05:50 PM
> *Subject:* Re: Top N without inline
>
> > > This might do the trick: > > WITH myview as > (SELECT
> pal_attained_mtd, DENSE_RANK () OVE...
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 23 2010 - 11:55:52 CDT