Re: Fetch the required rows - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Fetch the required rows
Date
Msg-id 20030826181339.GC17741@wolff.to
Whole thread Raw
In response to Fetch the required rows  (shyamperi@davlin.co.in)
List pgsql-sql
On Tue, Aug 26, 2003 at 23:15:48 +0530, shyamperi@davlin.co.in wrote:
> August 26th 2003
> 11:30p
> How do I get the required number of rows thru a query..
> I mean...If I want to show 10 tuples per page.. instead of getting all the tuples from the relation and do some front
endmanipulation, is there any way by which I can get only 10 required tuples from the relation
 

You can use limit and offset to do this.


pgsql-sql by date:

Previous
From: shyamperi@davlin.co.in
Date:
Subject: Fetch the required rows
Next
From: shyamperi@davlin.co.in
Date:
Subject: regarding the same in db2 - fetch tuples