Understanding FETCH

Hi,

I searched in the mailing list archive for question related to limiting 
the number of results.
What I want is exactly that, what has been discuses many time unter 
different topics.
I want to get only some rows of a longer table to show them on a web page.
I read that there isn't a limt x,y statment as in MySQL. The solution 
seems to be using the FETCH statement,
but I can't understand how.
Maybe someone can give me an example how to do it (it has to work with 
ODBC, because my web application uses PHP).