Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select a subset of records
<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