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: Best method to SELECT TOP n TO m of a table

Re: Best method to SELECT TOP n TO m of a table

From: Troels Arvin <troels_at_arvin.dk>
Date: Tue, 04 Nov 2003 20:24:04 +0100
Message-ID: <pan.2003.11.04.19.24.04.92089@arvin.dk> 





On Tue, 04 Nov 2003 14:15:04 +0000, Will Clark wrote:



> I was wondering if there was a better way to do a SELECT where it returns

> not the TOP 5 (or whatever) but, say, the TOP 6 to 8?




I have written about the subject here:


http://troels.arvin.dk/db/rdbms/#select-limit-offset


-- 
Greetings from Troels Arvin, Copenhagen, Denmark


Received on Tue Nov 04 2003 - 13:24:04 CST












Original text of this message













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