Re: select question

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: database(at)gurubase(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select question
Date: 2000-07-29 18:30:48
Message-ID: 20000729113047.G21967@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* database(at)gurubase(dot)com <database(at)gurubase(dot)com> [000729 10:57] wrote:
> Dear all,
>
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc.... (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different page.

I think you want to look at the OFFSET and LIMIT clauses explained in
the documentation.

-Alfred

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Turner 2000-07-29 18:43:58 Re: select question
Previous Message database 2000-07-29 17:54:56 select question