Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Most efficient way to create a view with current values

Re: Most efficient way to create a view with current values

From: Paul Linehan <plinehan__A_at_T__yahoo__D.OT__COM>
Date: Wed, 08 Aug 2007 19:17:17 GMT
Message-ID: <1Foui.21358$j7.383820@news.indigo.ie>

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
Received on Wed Aug 08 2007 - 14:17:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US