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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
