Re: Making query ONLY_FULL_GROUP_BY compatible
Those name dupes are indeed a problem. In this situation dupes are the rule and differences will be rare.
The only solution I see at the moment is to give the outer query in your example a GROUP BY too (and a MAX(description)). Not a very nice solution. Also, it gives problems when I add more fields: each extra field would mean one more nested query.
Do you know a better solution?
Subject
Written By
Posted
Re: Making query ONLY_FULL_GROUP_BY compatible
July 16, 2016 12:14AM
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.