Hi,
Please clarify how does the output of one is a single record/row and how does the output of
the second one is multiple records/rows

Let us consider emp table in Oracle

i wrote

Q1)select max(sal) from emp

now the output for the above statement might be 3600(lets say 3600 is the maximum salary)

Q2)select max(rowid) from emp

now the output for the above statement is of multiple rows. how does this happen
I would really appreciate if you could clarify the differences between how does the below work

a)max(sal)
b)max(rowid)
c)y the output of max(sal) is a single row record
d)y the output of max(rowid) is in multiple rows.