Question: what is the difference between aggregate and analytic functions in oracle?
Answer: Analytic Functions Versus Aggregate Functions. Like aggregate functions, analytic functions return aggregate results, but analytics do not group the result set. Instead, they return the group value multiple times with each record, allowing further analysis. ... Return the same number of rows as the input.