Re: Limit a result list

From: Joerg Banholzer <oracle_at_banholzer.de>
Date: Wed, 4 Dec 2002 11:03:58 +0000 (UTC)
Message-ID: <72ae327a17e1a2cf96ef240c942a107d.116041@mygate.mailgate.org>

"Alexander Zimmer" <zimmer_at_hollomey.com> wrote in message news:MPG.1857fe61a1217ac89896d2_at_news.cis.dfn.de

> The result should be the same, but the order may be not. If this poses a
> problem, you should add a "global" order by to the result.
>
> Anyway, the SET of selected rows should be identical in both cases.
>
> Alex

You are right, the order is is not the same. But in a few tests there are "always" just 8 rows of 10 which are the same, 2 are different?! I think I have to take a look at the database, which of the results the logically right one is...

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Dec 04 2002 - 05:03:58 CST