Re: how to retrieve specific number of rows
Thanks Felix! Now I see where I went wrong building that; of course, the LIMIT is evaluated *after* the set defined by subquery is returned, and because it will always contains at least one record, no LIMIT will ever prevent the WHERE from evaluating to true. I should of know better...Thanks again!
Subject
Written By
Posted
Re: how to retrieve specific number of rows
August 04, 2005 02:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.