Re: How to: Set resultset size?

Hi Roland,
One way to do it is:
Select * from table where rownum <= 20;

In article <8ub070$v0$1_at_nnrp1.deja.com>,   buurd_at_my-deja.com wrote:
> Hi!
> I have a webpage that queries a database for all rows in a table. Now
> this table has grown so large that it starts to affekt the network so
 I
> want to limit the size of the resultset in the query instead of in the
> page generator. I wanna do something like this
> select * from table where rows(0,20);
>
> I'll guess that there must be a syntax for that somewhere?
>
> Thanks in advance
> Roland Carlsson
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Philipp Spaniol
Wattstrasse 22
CH-4056 Basel Switzerland
Tel.: ++41 61 321 28 12


Sent via Deja.com http://www.deja.com/
Before you buy.