Thread: Fetch the required rows

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 

Have a grate day

-----
Warm Regards
Shÿam Peri

II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050


DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.

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.