Is it possible to return segments of results

Hi,

with some sql statements, we get result tables with more that 10000 rows.
Is it possible to return only a segment of the result (i think so, 
because it it's possible in sqlstudio).
If it is, plz. show me a example statement.

Thanks in advance for your help.

With best rgds.

Albert