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... > >