Re: LIMITING ROWS IN SELECT-STATEMENT
From: Dave Fowler <d.fowler_at_smmj.com>
Date: Fri, 04 May 2001 19:16:57 GMT
Message-ID: <JeDI6.64$Ur6.8300_at_newsread2.prod.itd.earthlink.net>
Date: Fri, 04 May 2001 19:16:57 GMT
Message-ID: <JeDI6.64$Ur6.8300_at_newsread2.prod.itd.earthlink.net>
[Quoted] Oracle uses the reserved word ROWNUM
"Ergün Ugurlu" <Erguen.Ugurlu_at_mathema.de> wrote in message
news:3AF2F395.FA8D9D22_at_mathema.de...
> 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 May 04 2001 - 21:16:57 CEST