Re: Order and limit not working as expected
Posted by:
Cid Dennis
Date: August 06, 2005 03:31PM
I have the same issue as Drew. I have a very large set of data that I want to sort for then do a limit on. However, even when I use group by it still does the limit first then the sort on what is left over. This is not optimal as I basicly have to remove the limit and do that work in my code which is considerably less efficent. Does any one know how to have the database sort first then limit after sorting?
Thanks
Subject
Written By
Posted
Re: Order and limit not working as expected
August 06, 2005 03:31PM
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.