Re: Null records create vastly different results
Your data determines your result, and we can't see it. To understand the subqueries, run them by themselves.
The subqueries do not aggregate. ...Group By id2... entails that the subquery will return one row per id2 value. What do you hope this Group By clause will accomplish?
Subject
Written By
Posted
Re: Null records create vastly different results
April 05, 2022 10:42AM
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.