Link to home
Start Free TrialLog in
Avatar of FranklinRaj22
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 .
Avatar of Christoffer Swanström
Christoffer Swanström
Flag of Switzerland image

Why would it matter? I don't think you can find out and it doesn't affect the end result
Avatar of Sean Stuber
Sean Stuber

they will be evaluated at the same time.

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
Avatar of Christoffer Swanström
Christoffer Swanström
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wouldn't a split be in order?