Re: restircting rows

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "padmanabha konkodi" <konkodi221(at)rediffmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: restircting rows
Date: 2006-02-22 09:23:40
Message-ID: D8960DB9-62BC-4060-82E7-45F94EA2195A@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Feb 22, 2006, at 18:06 , padmanabha konkodi wrote:
> my query return 100 rows but if i am intrested only from 40-60 rows
> then how to restrict.
>
> for example
>
> select * from students (returns 100 rows).but i am intrested only
> rows from 40 to 60.

See LIMIT and OFFSET.
http://www.postgresql.org/docs/8.1/interactive/sql-select.html#SQL-LIMIT

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2006-02-22 12:04:37 Feature, my misconception or bug??
Previous Message A. Kretschmer 2006-02-22 09:19:40 Re: restircting rows