Re: Obtaining a limited number of records from a long query

On Mon, 25 May 2009 14:55:54 +0100
"Oliveiros Cristina" <oliveiros.cristina@marktest.pt> wrote:

> 
> 
> Thanks a million, Andy.
> 
> It's precisely what I needed, Indeed!

Beware: unless you specify an ORDER BY (and you expect no other
record is inserted between one query and the other... or you just
don't care) you may incur in unexpected results.

A query without an order by is not granted to return the result in
the same order.

If you can (same session) you may use cursors.


-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it