Let me know <concept > for output of nested aggregation function as : select max(min(price)) from Products ?

Question

I have read in theory that multiple aggregation = innermost aggregation  ,So I was expecting  result as   min(price)

BUT

when I run this program on www.w3school.com  <SQL>  ,showing result as misuse of aggregation function min() !!

Answer 1

select max(min(price)) from product;

This will return minimum price. Because min(price) will get executed first and returns the only one value which is the minimum, now max() will start executing, which have only one value hence it will return that minimum. 

Read this for more insight. 

Comments

i had the command run in ORACLE 11g
i had the table as
 table1={1,2,3}

if i wrote select min(max(A)) from table1 group  by A : it gave me the minimum value

if i wrote select max(min(A)) from table1 group  by A : it gave me the maximum value

select avg(max(A)) from table1 group  by A  or if i wrote select avg(min(A)) from table1 group  by A  then it gave the same result that is average of the values of A.
though the inner query is executed first but the answer might vary according to which attribute is it being grouped by.
 

Answer 2

it wil return min price only