Re: How to: Set resultset size?

It is unfortunally not the answer I'm looking for.

The query returns the smallest resultset possible for the circumstance. But I don't want to move this large recordset from the database to the webserver but just the 20 rows that is going to be shown on a page. So I'm looking for a way to say.
For this query only return row 20-40 from the recordset. (row is not a column i a table)

Thanks
Roland

In article <8ub4p2$5f7$1_at_nnrp1.deja.com>,   Philipp Spaniol <philipp.spaniol_at_balcab.ch> wrote:
> 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.
>

--
Roland Carlsson
Certified Java programmer
Skövde
Sweden


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