Re: LIMITING ROWS IN SELECT-STATEMENT
From: Gary Thrower <Gary.Thrower_at_oracle.com>
Date: Fri, 13 Jul 2001 13:56:29 -0600
Message-ID: <3B4F526C.91BDCDB8_at_oracle.com>
Date: Fri, 13 Jul 2001 13:56:29 -0600
Message-ID: <3B4F526C.91BDCDB8_at_oracle.com>
Try replacing rowno with rownum. This should work to solve your question.
Gary Thrower
Ergün Ugurlu wrote:
> hi,
> how can i limit the number of rows a select-statement retrieves?
> in other databases it's handled like this:
> select * from 'tablename' where ROWNO <= 50
> to get 50 rows max.
>
> thanks for any help
Received on Fri Jul 13 2001 - 21:56:29 CEST