I think there isn't a portable way.
In Oracle each row of a query have a sequential number, called
"rowid", I think.
So, in oracle you do somethink like
...AND ROWID >= 0 AND ROWID <20
Disgusting, isn't it? :-)
On Mon, 2002-09-30 at 13:55, David Wall wrote:
> Does anybody know how to do this in a "portable" way? For example, I don't
> think Oracle has the LIMIT clause capability...
>
> David
>
--
Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893
Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@ritterdosreis.br
Fone/Fax.: (51)32303328