Re: Top N without inline
Date: Wed, 23 Jun 2010 17:55:52 +0100
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
On Jun 23, 2010 5:49 PM, "Stefan Knecht" <knecht.stefan_at_gmail.com> wrote:
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 :-)
- 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...