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: Select a subset of records

Re: Select a subset of records

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 9 Oct 2006 17:53:54 +0200
Message-ID: <452a7092$0$5060$426a74cc@news.free.fr>

<totaropeppe_at_yahoo.it> a écrit dans le message de news: 1160407105.060051.141410_at_m7g2000cwm.googlegroups.com...
| Hi,
|
| I'm an italian student and I've a problem with the selection of subsets
| of records.
| I do this selection with the following query:
|
| SELECT cols
| FROM (
| SELECT cols
| FROM table
| WHERE where_clause
| ORDER BY order_clause
| )
| WHERE ROWNUM BETWEEN limit1 AND limit2
|
| I think that this query is not efficient!
| Can you help me?
|
| Thank you.
| Giuseppe
|
| P.S.: Scuse me for my terrible english!!!
|

Goto AskTom (http://http://asktom.oracle.com) Put "limit result set" in the search box Read the fifth (at this moment) item.

Regards
Michel Cadot Received on Mon Oct 09 2006 - 10:53:54 CDT

Original text of this message

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