Re: select the last record in each group
doc, I cannot understood the rules you cite for generating your desired result; without more clarity, I cannot help you.
And again, to solve slowness, post the result of Explain Extended on the query.
Or if you don't wish to do that, study the examples under "Within-groupo aggregates" at
http://www.artfulsoftware.com/infotree/queries.php
Subject
Written By
Posted
Re: select the last record in each group
March 27, 2016 02:29AM
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.