Re: Aggregate with comparison
As a first pass at the problem, consider saving the result of the query you show above to a temp table, then work out the query logic required to extract the estimates you need. When that's producing correct results, you can then study how to do away with the temp table.
Subject
Written By
Posted
September 29, 2015 12:41PM
Re: Aggregate with comparison
September 29, 2015 04:23PM
September 30, 2015 12:45PM
September 30, 2015 03:23PM
September 30, 2015 03:45PM
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.