Re: limiting rows in an query

  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