FranklinRaj22
asked on
Aggregate Function priority - in ORACLE SQL
I have 2 aggregate functions both are MIN() like this
SELECT MIN(AVARCHAR),MIN(BDATE) from TAB1 GROUP BY .....
which of these aggregate function will be evaluated first .
SELECT MIN(AVARCHAR),MIN(BDATE) from TAB1 GROUP BY .....
which of these aggregate function will be evaluated first .
Why would it matter? I don't think you can find out and it doesn't affect the end result
they will be evaluated at the same time.
any minor internal ordering will completely invisible to you
any minor internal ordering will completely invisible to you
if, for some reason, you need one of them to be evaluated first, then try materializing subqueries to force a result or using 2 queries in sequence.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
wouldn't a split be in order?