MySQL Forums
Forum List  »  Newbie

Re: Aggregate with comparison
Posted by: Peter Brawley
Date: September 29, 2015 04:23PM

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.

Options: ReplyQuote


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
October 01, 2015 10:32PM


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.