Difference between aggregate function and analytical function?
- 3 Answers
- 30562 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / yogish naik
we can observe that the aggregate functions return only one
row per group whereas analytic functions keeps all the rows
in the group. Using the aggregate functions, the select
clause contains only the columns specified in group by
clause and aggregate functions whereas in analytic functions
you can specify all the columns in the table.
The PARTITION BY clause is similar to GROUP By clause, it
specifies the window of rows that the analytic funciton
should operate on.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is range partitioning?
Are null values same as that of zero or a blank space?
What are sql injection vulnerabilities?
What packages(if any) has oracle provided for use by developers?
How do I start sql profiler?
Is full outer join same as cross join?
Can we insert data into materialized view?
What is sql*plus?
Is trigger a stored procedure?
How can I tell if sql is running?
What are the various restrictions imposed on view in terms of dml?
Does varchar need length?
What does pragma mean?
How to write pl sql program in mysql command prompt?
What is a string data type in sql?
