Re: FETCH a Specific Amount of Rows from Query

Where I want to add that

   select * from table a where rownum < 10 order by a_column wiil NOT return the first 10 rows in te SORTED order. Oracle just stops retrieving rows after the first 10 rows are returned by the database engine - and that order is unpredictable. Then those rows get sorted.

Olaf Raether <olaf_at_raether.de> schreef in berichtnieuws hnvaavk2mq9p6gr11riqr8bnk6qg56q5f9_at_4ax.com...
|
| nearly the same
|
| select * from TABLE where ROWNUM < 10
|
| Olaf Raether
|
| On 22 Apr 2003 09:42:08 -0700, gilgantic_at_yahoo.com (gilgantic) wrote:
|
| >Hi,
| >
| >I know in DB2 you can use the FETCH keyword to get a specific amount of
rows
| >from a query. Example, SELECT * FROM A FETCH FIRST 10 ROWS ONLY, will
return
| >on the first 10 rows of a result set. How is this done in Oracle 8i., or
is
| >it even possible? The FETCH keyword is used differently in Oracle 8i as I
| >understand it.
| >
| >Thanks!
| >Gil
|
Received on Tue Apr 22 2003 - 12:55:28 CDT