Re: [GENERAL] select question

[Alfred Perlstein]

* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [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