Re: Top N without inline
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: knecht.stefan@xxxxxxxxx
- 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
Niall Litchfield
On Jun 23, 2010 5:49 PM, "Stefan Knecht" <knecht.stefan@xxxxxxxxx> 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@xxxxxxxx 10046
Consulting GmbH Schwarzac...
On Wed, Jun 23, 2010 at 6:27 PM, Dave Pacia <davepacia@xxxxxxxxx> 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@xxxxxxxxx>
> *To:* davepacia@xxxxxxxxx
> *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...
>
>
Other related posts:
