LIMITING ROWS IN SELECT-STATEMENT
From: (wrong string) ün Ugurlu <Erguen.Ugurlu_at_mathema.de>
Date: Fri, 04 May 2001 20:23:17 +0200
Message-ID: <3AF2F395.FA8D9D22_at_mathema.de>
Date: Fri, 04 May 2001 20:23:17 +0200
Message-ID: <3AF2F395.FA8D9D22_at_mathema.de>
hi,
[Quoted] 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 - 20:23:17 CEST