Re: Limiting the number of returned rows with Oracle

adding the clause 'where rownum < 5'

will have the effect of only returning 4 rows.

However in the relational world there is no guarantees as to which rows these will be. You may need to 'order' them if you need to pick out either end of a sequence.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
<converse_at_tanyelcp650.brightware.com> wrote in message
news:393C7E63.345F9DE8_at_tanyelcp650.brightware.com...


> Is there a way to limit the number of returned records to a given number

> with Oracle with SQL?

>

> Something like: "select * from table and return first five rows"

>

> thanks,

>

> Cem

>

>

>