Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!feeder.news-service.com!feed.xsnews.nl!border-1.ams.xsnews.nl!217.145.39.3.MISMATCH!talisker.lacave.net!lacave.net!news.stack.nl!feeds.news.ox.ac.uk!news.ox.ac.uk!feed2.jnfs.ja.net!feed4.jnfs.ja.net!jnfs.ja.net!feeder.news.heanet.ie!news.indigo.ie!not-for-mail From: "Paul Linehan" Subject: Re: Most efficient way to create a view with current values Newsgroups: comp.databases.oracle.misc References: <9fe91$46a4fd59$53545461$27750@cache110.multikabel.net> <1185221295.752979.223310@22g2000hsm.googlegroups.com> User-Agent: XanaNews/1.18.1.6 Lines: 24 Message-ID: <1Foui.21358$j7.383820@news.indigo.ie> Date: Wed, 08 Aug 2007 19:17:17 GMT NNTP-Posting-Host: 83.71.38.12 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1186600637 83.71.38.12 (Wed, 08 Aug 2007 20:17:17 BST) NNTP-Posting-Date: Wed, 08 Aug 2007 20:17:17 BST Organization: Eircom.Net http://www.eircom.net Xref: usenetserver.com comp.databases.oracle.misc:249164 X-Received-Date: Wed, 08 Aug 2007 15:17:18 EDT (text.usenetserver.com) John K. Hinsdale wrote: > Hope that helps. Great clear post - wish there were more like them on newsnet! Would you happen to have a similar lucid explanation of RANK, DENSE RANK and ROWS/FIRST? I've never been able to get my head around which clause returns what. Paul... > John Hinsdale