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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Can I do this using SQL?

Re: Can I do this using SQL?

From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Fri, 10 Feb 2006 13:14:37 +0100
Message-ID: <dsi04m$lmf$1@online.de> 





Dieter Noeth wrote:



> ROW_NUMBER -> exactly 10 rows

> RANK -> then rows plus all the rows with the same value as the 10th.




RANK -> ten rows plus all the rows with the same value as the 10th.



> DENSE_RANK -> all the rows with the 10 highest distinct values

Received on Fri Feb 10 2006 - 06:14:37 CST












Original text of this message













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