* database@gurubase.com <database@gurubase.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