Obtaining a limited number of records from a long query

Dear List,

 

Is there any way to force a query to return just a few records?

 

For ex, returning just the first ten rows from a long ORDER BY query ?

 

And then, eventually, obtaining the remaining records at a later time, or in background?

 

Thanks in advance for your help,

 

Best,

Oliveiros