X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 031CD9DCA43 for ; Wed, 22 Feb 2006 05:14:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65153-03 for ; Wed, 22 Feb 2006 05:14:08 -0400 (AST) X-Greylist: delayed 00:06:37.721462 by SQLgrey- Received: from rediffmail.com (unknown [203.199.83.35]) by postgresql.org (Postfix) with SMTP id 0E1F99DC893 for ; Wed, 22 Feb 2006 05:14:03 -0400 (AST) Received: (qmail 17854 invoked by uid 510); 22 Feb 2006 09:06:57 -0000 Date: 22 Feb 2006 09:06:57 -0000 Message-ID: <20060222090657.17853.qmail@webmail49.rediffmail.com> Received: from unknown (220.227.202.145) by rediffmail.com via HTTP; 22 feb 2006 09:06:55 -0000 MIME-Version: 1.0 From: "padmanabha konkodi" Reply-To: "padmanabha konkodi" To: pgsql-sql@postgresql.org Subject: restircting rows Content-type: multipart/alternative; boundary="Next_1140599215---0-203.199.83.35-17776" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.764 required=5 tests=[AWL=-0.305, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, HTML_IMAGE_ONLY_08=2.435, HTML_MESSAGE=0.001, HTML_SHORT_LINK_IMG_1=0.275, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 3.764 X-Spam-Level: *** X-Archive-Number: 200602/257 X-Sequence-Number: 24267 This is a multipart mime message --Next_1140599215---0-203.199.83.35-17776 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =0A =0Ahi all,=0A=0Amy query return 100 rows but if i am intrested only = from 40-60 rows then how to restrict.=0A=0Afor example=0A=0Aselect * from s= tudents (returns 100 rows).but i am intrested only rows from 40 to 60. --Next_1140599215---0-203.199.83.35-17776 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A 
=0A 
=0Ahi all,
=0A
=0Amy query return 100 = rows but if i am intrested only from 40-60 rows then how to restrict.
= =0A
=0Afor example
=0A
=0Aselect * from students (returns 100 rows= ).but i am intrested only rows from 40 to 60.=0A

=0A

=0A=0A --Next_1140599215---0-203.199.83.35-17776--