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.or
padmanabha konkodi wrote:
hi all,
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.
SELECT * FROM student ORDER BY something LIMIT 20 OFFSET 40;
Be awa
am 22.02.2006, um 9:06:57 - mailte padmanabha konkodi folgendes:
>
>
> hi all,
>
> 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.
hi all,
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.
