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 .
FranklinRaj22Asked:
Who is Participating?
 
Christoffer SwanströmPartnerCommented:
In your example the two expressions are completely independent.  Execution order will not affect the end result. As sdstuber points out, you can nest the expressions inside subqueries if one depends on the output of the other.
0
 
Christoffer SwanströmPartnerCommented:
Why would it matter? I don't think you can find out and it doesn't affect the end result
0
 
sdstuberCommented:
they will be evaluated at the same time.

any minor internal ordering will completely invisible to you
0
 
sdstuberCommented:
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.
0
 
sdstuberCommented:
wouldn't a split be in order?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.