[GENERAL] select question

[database]

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.

Many thanks.

Best regards,
Boris