Question: what is the difference between max and greatest in oracle?
Answer: There are a few differences between the Oracle GREATEST and MAX functions: Both MAX and GREATEST will return one result, but MAX is an aggregate function and GREATEST is not. GREATEST can return multiple rows. It will return one row for each row of data you query as it is not an aggregate function.